AW: [PHP] CLIKE in MySQL-Query
| From: | bemorph | Date: | Mon, 28 Aug 2000 15:20:14 +0000 |
| Subject: | AW: [PHP] CLIKE in MySQL-Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-13954@lists.php.net to get a copy of this message | ||
it doesn't work eiter:
$query = mysql_query("SELECT BINARY FROM users WHERE
frage='$recover_frage' AND antwort='$recover_antwort' AND
username='$recover_username' AND email='$recover_email' AND
deleted='0'");
$ok = mysql_num_rows($query); <----- Warning: Supplied argument is not
a valid MySQL result resource in
C:\HTTPD\HTDOCS\BEMORPH\recover_passwort.php3 on line 15
I run MySQL 3.22.34-shareware-debug running on localhost
> -----Ursprüngliche Nachricht-----
> Von: andreas (@work) [mailto:viva@mcnon.com]
> Gesendet am: Montag, 28. August 2000 16:17
> An: info@bemorph.de
> Cc: php-general@lists.php.net
> Betreff: Re: [PHP] CLIKE in MySQL-Query
>
> hi,
>
> use BINARY if you run mySQL >= 3.23.0
>
>
> samples:
>
> msql> select "a" = "A";
> -> 1
>
> msql> select BINARY "a" = "A";
> -> 0
>
> where 1 .... true 0 .... false
>
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> _/_/ viva technologies
> _/ gstrein andreas
>
>
>
> > for example a valid combination of 'frage' and 'antwort' would be:
> >
> > frage: hello there
> > antwort: my name is jochen
> >
> > the following combination should not be allowd:
> >
> >
> > frage: Hello There
> > antwort: my name is jochen
> >
> > but the follwing line accepts bothe combinations?
> >
> > what's wrong????
> >
> > $query = mysql_query("SELECT pass FROM users WHERE frage CLIKE
> > '$recover_frage' AND antwort CLIKE '$recover_antwort'");
> >
> >
> > jochen kächelin
> >
> > mailto:info@bemorph.de
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>