SELECT * FROM calendar WHERE date_column = CURDATE() ---John Holmes...
> -----Original Message----- > From: Thomas Goeminne [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 27, 2002 5:25 AM > To: [EMAIL PROTECTED] > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php