Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Displaying mysql data

4:17 am on Aug 2, 2011 (gmt 0)

New User

5+ Year Member

joined:Aug 2, 2011
posts: 1
votes: 0

I have a table with ID, firstname, status and above the table I want 4 links that read all, hot, warm, cold. By clicking on the link the table below will only show those users whose status = hot. Is it best to create new pages in php to display all the users for the corresponding status or is there a better way to do it so that it's all done one a single page?

Thank you in advance!
3:54 pm on Aug 2, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 28, 2004
votes: 0

select * from users where status = 'hot'

Then in your while loop, output links to the individual users (?)