comparing 2 timestamp

tenma-tenma · #1 (**permalink**) 06-05-07, 13:11

Hi,

i would like to compare two value of timestamp

so my code is

Code:

$todayDate= date("Y-m-d 00:00:00");
$todayEnd= date("Y-m-d 23:59:59");

$query_reg_list= "select p.patientId, m.MRId, p.pname, p.alergi";
$query_reg_list.=" from MR m, patient p, havePatient h where h.MRId=m.MRId and h.patientId=p.patientId and regDate>='$todayStart' and regDate<='$todayEnd' order by p.patientId";

does anyone know how to compare these values? cause i always get empty result for that..
thank's for our attention

r937 · #2 (**permalink**) 06-05-07, 15:11

please echo the sql after the variable substitution, i.e. instead of executing it

we need to see the same sql that mysql sees, e.g. if you were to run your query outside of php