comparing time in mysql + php
Posted: Tue Jan 21, 2003 10:00 am
Sorry but i don't have much time to research. I'm cramming up with my work now.
How do I set current time in a time/data column in mysql through PHP?
How about SELECTing rows that have date/time column (assume DATE_TIME) 5 min from current time?
"SELECT row1 from table1 where DATE_TIME ?????? "
thanks a lot!
How do I set current time in a time/data column in mysql through PHP?
How about SELECTing rows that have date/time column (assume DATE_TIME) 5 min from current time?
"SELECT row1 from table1 where DATE_TIME ?????? "
thanks a lot!