Re: No results from query

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_/