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. Link to comment https://forums.phpfreaks.com/topic/56815-solved-display-one-or-the-other/ 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'"); Link to comment https://forums.phpfreaks.com/topic/56815-solved-display-one-or-the-other/#findComment-280705 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 Link to comment https://forums.phpfreaks.com/topic/56815-solved-display-one-or-the-other/#findComment-280706 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 Link to comment https://forums.phpfreaks.com/topic/56815-solved-display-one-or-the-other/#findComment-280709 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.