[MySQL] Sometimes I get empty rows from SELECT query...
| From: | Michal Pleban | Date: | Sat, 28 Aug 2004 16:15:24 +0000 |
| Subject: | [MySQL] Sometimes I get empty rows from SELECT query... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35922@lists.php.net to get a copy of this message | ||
Hello!
I'm writing a PHP script which accesses a MySQL database. As it turns out, sometimes I get an empty row from a SELECT query which should normally return one or more rows. The same query executed a while later, on unchanged data, returns the rows perfectly fine. No errors are returned, just mysql_fetch_array simply returns nothing. What can be a caouse of this? Perhaps I forgot to put mysql_free_result somewhere, and it causes such effects? Anyone had this problem before?
Best regards,
Michau.