RE: [PHP] current date query

From: Date: Sat, 27 Apr 2002 17:32:59 +0000
Subject: RE: [PHP] current date query
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-94895@lists.php.net to get a copy of this message
SELECT * FROM calendar WHERE date_column = CURDATE() ---John Holmes... > -----Original Message----- > From: Thomas Goeminne [mailto:dabomb_gent@hotmail.com] > Sent: Saturday, April 27, 2002 5:25 AM > To: php-general@lists.php.net > Subject: [PHP] current date query > > Hi, > > I am a beginning programmer and I am missing my Mysql/php book for some > days > so I can't look up what i need. > > i need a query something like this: > > query= SELECT from calender WHERE ('$day','$month','$year')= > current date > > i need a script that looks in my database for events that are going down > the > day my visitor visits the page and if there are no parties today it > returns > something like: sorry no parties today. > > thanks and let me know > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php

« previous php.general (#94895) next »