Displaying mysql data

[Illfigureitout]

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!

[rocknbil]

select * from users where status = 'hot'

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