Re: Strange MySQL Query Problem
| From: | Alberto Serra | Date: | Thu, 04 Jul 2002 04:41:12 +0000 |
| Subject: | Re: Strange MySQL Query Problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-105370@lists.php.net to get a copy of this message | ||
eat pasta type fasta wrote:
$result = mysql_query("SELECT some_id, some_description, some_feature FROM '$pop-up1' WHERE some_description LIKE '%$texfield%' AND some_feature LIKE '%$pop-up2'");have this query echoed to video and then cut it and paste it to mysql terminal. Most probably you'll find out that it's an uppercase/lowcase problem. Unlike Oracle Mysql IS case sensitive on tablenames and columnnames. Alberto Kiev -- @-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@ LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is.......