Page 1 of 1

strange problem with SELECT

Posted: Thu Aug 26, 2004 3:46 am
by pelegk2
i have this select :

Code: Select all

SELECT * FROM order_h WHERE del_id>0 and (dt<=1093557599 AND dt>=1093471200 AND TEUDAT_MISH='') OR FROM_UNIXTIME(TAARICH_T,'%Y %d %m')=FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %d %m') order BY region_id asc
the problem is that i ask for all the del_id>0 but for some strange reason i get del_id==0 !!!! why is that ?>
del_id is defind as int unsigend not null
what wrong

Posted: Thu Aug 26, 2004 4:19 am
by bugthefixer
try this

Code: Select all

SELECT * FROM order_h WHERE del_id>0 and (dt<=1093557599 AND dt>=1093471200 AND TEUDAT_MISH='') AND FROM_UNIXTIME(TAARICH_T,'%Y %d %m')=FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y %d %m') order BY region_id asc
OR is replaced with AND
?>

Posted: Thu Aug 26, 2004 5:10 am
by pelegk2
now i get 0 results which immpossible

Posted: Thu Aug 26, 2004 6:40 am
by ody
some sample data would'nt go amiss..