Re: [PHP-DB] No results from query

2002-04-08 Thread Marius Ursache
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

Re: [PHP-DB] No results from query

2002-04-08 Thread Lisi
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, wh

Re: [PHP-DB] No results from query

2002-04-08 Thread Marius Ursache
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 followin