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