Re: Query dies silently

2005-10-17 Thread Erich C. Beyrent
Gleb Paharenko wrote: Hello. I get 142k rows back in just over 4 seconds. It means that on the server side query works, so the problem probably is in PHP. Good call. I did some testing, and sure enough, the mysql_query() is successful. The failure comes in trying to retrieve the rows

Re: Query dies silently

2005-10-15 Thread Gleb Paharenko
Hello. I get 142k rows back in just over 4 seconds. It means that on the server side query works, so the problem probably is in PHP. However, when I run this query using PHP through the browser, I get nothing at all. Occasionally, I get get an error about not being able to store

Query dies silently

2005-10-14 Thread Erich C. Beyrent
Hi all, I have a rather strange problem that I cannot seem to figure out. When I run the following query from the MySQL console: SELECT Inventory.ID as InventoryID, Inventory.Name, Inventory.Capacity, Inventory.Beds, Avails.ID as AvailabilityID,