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 (?)

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members