how to delete on a certain date

kappaluppa

I'm trying to write a simple little event list (not a calendar, just a list of events). But I want the items to drop off when the event passes. I assume the code will be based on the user's computer clock.

Something like select all dates => than today. (I'm new to writing my own code, so please bear with me. I usually rely on the good peoples at phpBuilder.com to supply me with what I need).

Would it be something like:
"SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format from $TableName where date => TODAY ORDER BY date desc"

What is the correct syntax for the "today" part and the "=>" part?

Thanks!
Kathy

volleytotal_ch

if you're date field in the table has the format YYYY-MM-DD, you can jsut use this code

$query = "SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format from $TableName where date >= '".date("Y-m-d")."' ORDER BY date desc";
// See the >= (not the => as you've written)
// see the ' ' around the date

more information about using date()

Wien

even easier with NOW()

$query = "SELECT *, DATE_FORMAT(date, '%m-%d-%Y') AS date_format from $TableName where date >= NOW() ORDER BY date desc";

kappaluppa

I tried the NOW () suggestion, but it didn't work. None of my code shows up now.

thanks...

kappaluppa

Ok, the NOW () works. Turns out in my example, and consequently the suggested remedies, had the wrong field name! (begin_date, rather than date).

Funny how things work when you put in the correct information!

Thanks a bundle!

PS
This is the page where my little events list is at. But almost all of my clients have asked for something like this, so it will be a great help! Thanks again!
http://www.echoonline.org/events.php