No results from query
| From: | Lisi | Date: | Tue, 09 Apr 2002 07:18:05 +0000 |
| Subject: | No results from query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18341@lists.php.net to get a copy of this message | ||
I have the following query:
SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh'
which produces no results, when I set
$numrows = mysql_num_rows($result);
it equals 0.
When I do the following:
SELECT * FROM ayny
and then loop through the results, echoing them to the screen with the following code:
while ( list($key,$val) = each($result_array) ) {
echo "$key = $val<BR>";
}
I do get a line
organization = Hatzoloh
So why can't I pull just the record for Hatzoloh using my first query?
Please let me know if you need more code to figure this out.
Thanks,
-Lisi