Re: mysql string comparison not working
| From: | lallous | Date: | Tue, 03 Sep 2002 10:45:44 +0000 |
| Subject: | Re: mysql string comparison not working | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114999@lists.php.net to get a copy of this message | ||
try to:
var_dump($row[24])
and see what happens?
it might be that the "Y" is stored as lowercase in MySql's table.
Elias
"David Banning" <david@skytrackercanada.com> wrote in message
news:20020903023307.A81049@skytrackercanada.com...
> if I set test = "Y";
> then
>
> if ($test == "Y") {echo ("it matches");}
>
> seems to work while
>
> if ($row[24] == "Y") {echo ("it matches");}
>
> does not.
> The row[24] mysql variable is char type and 1 char long.
>
> any idea why it is not doing the comparison?