Re: No results from query

Lisi a écrit : > That worked...why? > because in your table you wrote "_SPACE_Hatzoloh_SPACE_" or _NEWLINE_Hatzoloh_NEWLINE_ ...any way you wrote "Hatzoloh" and some caracter that you don't see it so easy (space, tab, new_line). % is like * on regular expresion (wildcard) > > -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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- Marius Ursache (3563 || 3494) \|/ ____ \|/ "@'/ ,. \`@" /_| \__/ |_\ \__U_/