[RESOLVED] Hyperlink from SQL Statement

I am trying to make a Navigational Menu on my website.

The tabs are as follow: HOME | ABOUT US | CONTACT US | RESIDENTIAL |COMMERCIAL |

Home, About Us and Contact Us are straight foward static pages. However, Residential and Commercial are both dynamic pages and the information is pulled from a Mysql database using php.

I have basically designed the full database and coding etc, however, the last step now is to actually make a link…

consider the following statement:

[code=php]SELECT * FROM `Property` where `Type` = 1[/code]

I would like that when Type = 1 (i.e. Residential), a user can click the Residential Tab and view All residential properties. And the same for Commercial which is Type = 2

Thanks…

p.s. <a href=”SELECT * FROM `Residential` where `Status` = 1″>Residential</a> is basically what I would like to acheieve.

Also in #PHP _↴