Is it possible to search a mysql database for a matching time, give or take a minute or to. So you name a time and then search for a matching time and show all that match and all that are within 2 minutes?
Cheers Jules@hungrybear.co.uk
add a where clause like this:
WHERE your_field BETWEEN DATE_SUB(your_field, INTERVAL 2 MINUTE) AND DATE_ADD(your_field, INTERVAL 2 MINUTE)
g'luck,
jack
Yes ofcourse, but you must workaround it a bit.
Take you original time and substract a minute (unix timestamp is easy) and you add one minute. Do your query with WHERE $sub < time AND time > $add
Do you ahve a working example I could see? My SQL field is called time. How can I query it? Thanx!
