September 3rd, 1999, 11:16 PM
I have a date (LastDate) column in mySQL table. How can I make a search query in PHP to show all the rows where the date is lessthan today (ie: Or 'LastDate' has not expired)
September 4th, 1999, 11:25 PM
$selectfiles = "SELECT * FROM [tablenane] WHERE $lastdate < $currentdate;";
Basicly just compares dates in database with current date. Replace "*" with the fields you want or leave it to get all the fields.
new media arts