mysql_fetch_array error

[Anon]

I'm trying to do a form query which searches my database. However I have always the folowing problem.

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/home/web/result.php on line 16
No Record Found

Could somebody check the lines and tell me what is wrong? I use Mysql/php4.
$query = mysql_query(\"SELECT * FROM $usertable WHERE $metode LIKE \'%$search%\' LIMIT 0, 30 \");
while ($row = mysql_fetch_array($query))
thanks for your help
Dan

[Anon]

Hey:

Right after the $query = ... line, type:

echo mysql_error();

and it will tell you what the problem is. There is an error in your sql somewhere. Hope that helps.

Chris King

[Anon]

I get this message when I add the echo text

Unknown column 'row_name1' in 'where clause'
what does this mean?
Thanks
Dan

[msteward]

Dan,

I think you have to write it like this:

$query = "SELECT * FROM $usertable WHERE $metode LIKE '%$search%' LIMIT 0, 30";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))