Page 1 of 1

mysql_fetch_array question

Posted: Sat Aug 05, 2006 5:57 pm
by eektech909
i'm displaying date from a mysql table by date in php
i'm going to have it compare dates so it won't display anything that has a date earlier than the current date (so it expires)
i run a mysql_query and then fetch the data and then display it in a table on the site.

so how do i have it skip (not display) a row that is "expired" and just continue on to the next entry?

Posted: Sat Aug 05, 2006 6:09 pm
by Weirdan

Code: Select all

select * from table where column>'$expire_date'

Posted: Sat Aug 05, 2006 6:10 pm
by feyd
I'm with Weirdan on this. Write the proper query to exclude the information you don't want beforehand.