Hi all,
I have been tearing my hair out for weeks with this problem, hope someone
can help.
I want to pull all data out of a mysql table that falls between two dates (a
start-time and end-time).
I use PHP to allow the user to specify the time interval, creating 2
variables
'startTime' and 'endTime'. These are formatted thus: 2002-02-25 00:00:00
(YYYY-MM-DD HH:mm:ss).
I then use the syntax:
$query = "select * from Job_TB where teamNo = $teamNo AND startTime >=
$timeFrom AND endTime <= $timeTo";
$result = mysql_query($query,$db) or die ("somethings wrong");
to query the mysql DB. But it doesnt work. Is there a glaring error in my
syntax?
Can anyone help with this as its driving me nuts
Hope someone can help, thanks in advance,
brad
Cheers,
Brad
Nel vino la verità, nella birra la forza, nell'acqua i bacilli
--------------------------------------------------------------------------
In wine there is truth, in beer there is strength, in water there are
bacteria
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
