Re: [PHP-DB] 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";
> > > }
> > >
> > > 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
Re: [PHP-DB] No results from query
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";
> > }
> >
> > 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
Re: [PHP-DB] 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";
> }
>
> 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
