The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community

Geekfinder
UFie Gear
Advertise on UF

Forum Rules
& FAQ


Username

Password


Create a New Account

 
 

Back to UserFriendly Strip Comments Index

php/mysql inquery by resc 2007-01-22 04:38:12
I've created an event handler for a website.
Earlier I got a suggestion to use NOW() in the mysql query.
or rather >=NOW() to ble able to select events from today and onwards... but it's not working as expected.. because it doesn't take into concideration the time... the time is in another field.
How can I tell NOW() to take certain value?
can I tell it to look for a specific time? or is this the only way to use it?
[ Reply ]
  If you don't get an answer before then, by volg2007-01-22 04:42:08
    nevermind... by resc2007-01-22 04:50:09
  speed answer by volg2007-01-22 04:50:13
  CURDATE and CURTIME might do it then by sazzer2007-01-22 04:55:04

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)