No results from query

From: 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

« previous php.db (#18341) next »