I am trying to perform a mysql query through a php page.
The query involves querying a time type field in my database 00:00:00
The value it is queried by is recieved from a value from a drop down list.
I have used the following query:
Code: Select all
mysql_query("Select * from activities where learn_time > '$start_time'");where $start_time is represented by a value in the following format 00:00:00 e.g. 03:00:00
but I get a query error :
You have an error in your SQL syntax near ':00:00' at line 1
any ideas what is wrong do I need to specify that the value is a time format or something??
thanks
alex