comparing time in mysql + php

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Kyori
Forum Newbie
Posts: 23
Joined: Mon Oct 14, 2002 5:23 am
Contact:

comparing time in mysql + php

Post by Kyori »

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!
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Check out this thread:
viewtopic.php?t=5790

Mac
Post Reply