Description: ------------ Query doesn't work with DB while it works with standard php mysql. After issuing: echo "BEFORE"; if(!($result = $db_object->query($query))){ die("ERROR"); } echo "HI"; Nothing comes out of it. seems like it dies. I neither see ERROR or HI printed on the screen, while I see before. Reproduce code: --------------- SELECT pt.pt , (regels.pick_date) as pick_date , (ship.ship_date) as ship_date , sum(aant_gepick) as aantal FROM ( pt left join regels on pt.pt=regels.pt ) left join ship on pt.pt=ship.pt where (pick_date between '2003-12-1' and '2003-12-15') and ( (ship_date not between '2003-12-1' and '2003-12-15') or (ship_date is null) ) group by pt.pt order by pick_date ;

Description: ------------ Query doesn't work with DB while it works with standard php mysql. After issuing: echo "BEFORE"; if(!($result = $db_object->query($query))){ die("ERROR"); } echo "HI"; Nothing comes out of it. seems like it dies. I neither see ERROR or HI printed on the screen, while I see before. Reproduce code: --------------- SELECT pt.pt , max(regels.pick_date) as pick_date , max(ship.ship_date) as ship_date , sum(aant_gepick) as aantal FROM ( pt left join regels on pt.pt=regels.pt ) left join ship on pt.pt=ship.pt where (pick_date between '2003-12-1' and '2003-12-15') and ( (ship_date not between '2003-12-1' and '2003-12-15') or (ship_date is null) ) group by pt.pt order by pick_date ;

In mysql.php::simpleQuery($query) there is a line: $result = @mysql_query($query, $this->connection); it seems to work after changing it to: $result = @mysql_query($query);//, $this->connection); Why is that? And why does it work with other queries? Thanks, Jeroen

Problem was timing. After setting: set_time_limit(0); The problem went away. I don't understand why, because php used to give a warning when timer went of. Sorry for the misplaced bug. Jeroen