Hi,

i would like to compare two value of timestamp

so my code is

$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

The date function I think is messing you up. Here is an attempt modified with the sql between function.

PHP Code:

$query_reg_list = 'SELECT p.patientId, m.MRId, p.pname, p.alergi '
                . 'FROM MR m, patient p, havePatient h '
                . 'WHERE h.MRId = m.MRId AND '
                . 'h.patientId = p.patientId AND '
                . 'regDate BETWEEN "' . date('Y-m-d') . ' 00:00:00" AND "' . date('Y-m-d') . ' 23:59:59" '
                . 'ORDER BY p.patientId'; 


hi..
thank's for your reply..
i've tried your code, but it still give me empty result with 2 warnings in mysql =)

warning 1292: incorrect datetime value: '' .date('Y-m-d') . ' 00:00:00' for column 'regDate' at row 1
warning 1292: incorrect datetime value: '' .date('Y-m-d') . ' 23:59:59' for column 'regDate' at row 1

i've tried to change the date() function to curdate() but it still gives me empty result and same warnings..
can you please help me with this problem? thanks a lot..

regards,

Your error is stating that you are passing literal php code to your sql - Is PHP turned on?

You can use sql to do this completely

SELECT p.patientId, m.MRId, p.pname, p.alergi 
FROM MR m, patient p, havePatient h 
WHERE h.MRId = m.MRId AND 
h.patientId = p.patientId AND 
regDate BETWEEN DATE_FORMAT(NOW(), "%Y-%m-%d 00:00:00") AND DATE_FORMAT(NOW(), "%Y-%m-%d 23:59:59") 
ORDER BY p.patientId

Hi..
thank's for the repliess..
that's work... =)
thank's a lot