Re: No results from query

That worked...why? -Lisi At 09:23 AM 4/9/02 +0300, Marius Ursache wrote:

Lisi a écrit : I have the following query: SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh' try "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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Marius Ursache (3563 || 3494)

                           \|/ ____ \|/
                           "@'/ ,. \`@"
                           /_| \__/ |_\
                              \__U_/

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php