PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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
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