Mark Hensler — Sun, 21 Jan 2001 22:45:24 +0000

the datetime thing came be avoided it you use the TIMESTAMP data type in the mySQL DB.

Simply provide the user with dropdowns or whatever (as Maverick suggested).
Then, use the mktime() function to create a timestamp to use in your queries.

To put info into the DB, use the time() function to insert a timestamp into your timestamp field.

Good Luck,

Maverick — Sun, 21 Jan 2001 22:20:35 +0000

Actually, you are probably going to need to manipulate things a bit with PHP. That SQL query is fine, but don't forget that MySQL will store a datetime field as "2001-01-21 17:15:00" for 5:15 pm January 21st, 2001 (the time I'm writing this) and you need really really smart users to be able to enter their search queries in such a structured format. If they use a period instead of a colon, the query will fail. I'm assuming that you'll want to make things a bit easier on them, I.E., allow them to choose month, date, time ranges, etc, from a series of drop down lists or radio buttons. If that's the case, you'll need a little PHP to combine the various pieces of the search string into a something that MySQL can understand. For example, assume you use separate variables for year, month, day, hours, minutes and seconds, you'd need to combine them into a proper string like:

$searchstring="$year-$month-$day $hours:$minutes:$seconds";

then, you can use that $searchstring to query the database to assure that it's in a format that matches the datetime field.

Gil — Sun, 21 Jan 2001 06:05:46 +0000

Wow I didn't think it would be THAT easy. I figured you're have to do some PHP work for that. MySQL is a great thing...

Mark Hensler — Sun, 21 Jan 2001 05:59:19 +0000

simple...

in your query say:
"WHERE field_name >= date_time AND field_name <= date_time"

As for user defined, just replace "date_time" with $user_time (or whatever you call the var)

I recomend you use timestamps for ALL your date/time storage. You can then pull any date/time info out of it that you wish.