Strange MySQL Query Problem
| From: | eat pasta type fasta | Date: | Thu, 04 Jul 2002 04:32:48 +0000 |
| Subject: | Strange MySQL Query Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105356@lists.php.net to get a copy of this message | ||
I already got some replies for this but it wasn't it, here is the problem:
I have a simple form which queries the database based on 2 pop-up menu
choices and keywords entered by the user,
it passes on the variables as follows:
pop-up1=choice1, pop-up2=choice2, textfield=user specified data
the query is as follows
$result = mysql_query("SELECT some_id, some_description, some_feature
FROM '$pop-up1' WHERE some_description LIKE '%$texfield%' AND
some_feature LIKE '%$pop-up2'");
it tells me that column which equals to the $texfield does not exists,
meaning that the query seems to be fed wrong? No idea here, $texfield and
$pop-up2 are not requests for tables but matches in those tables
a bit buffled I am, I've these queries before on larger web servers, this
is the first time on my workstation and it does just that, simpler
queries work fine...
thanks in advance,
R>
ps. the form is guarded against empty entries
ps2. RedHat 7.3, Mysql 3.23.51, Apache 1.3+ wik PHP 4.2.1 configured for
MySQL