ryeman98 Posted June 23, 2007 Share Posted June 23, 2007 Hi there! I've created a page where there are 2 categories of a list of projects. The first one is Current Projects where it'll display current projects and another that is Future Projects. In my database, I have a column called 'status' which can either be current or future. How can I make it so that the Future Projects will only display the projects when the status 'future' and the Current Projects display when the status is 'current' I've attempted a few things but they don't work, both lists will show all of the entries. Quote Link to comment Share on other sites More sharing options...
rcorlew Posted June 23, 2007 Share Posted June 23, 2007 $query = mysql_query("SELECT * FROM table_name WHERE satus = '$my_status'"); Quote Link to comment Share on other sites More sharing options...
teng84 Posted June 23, 2007 Share Posted June 23, 2007 have you done any query let us see and we will modify it for you Quote Link to comment Share on other sites More sharing options...
ryeman98 Posted June 23, 2007 Author Share Posted June 23, 2007 Thanks rcorlew! I completely forgot to add in the WHERE! xD Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.