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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php