Warning: mysql_fetch_assoc():

[marblo]

It seems as though I have a problem i can`t solve... I´m not advanced enough to see what I´m doing wrong.

I keep getting this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result

PHP:
<?
$name = $HTTP_POST_VARS["name"];
$db = mysql_connect("localhost");
mysql_select_db("feedback", $db);
$query = "select * from shops where name like ?%".$name."%?";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)) {
while (list($fieldname, $fieldvalue) = each ($record)) {
echo $fieldname.": ".$fieldvalue."<BR>";
}

echo "<BR>";

}
?>

I am assuming it has something to do with where name like ?%".$name."%? because the error doesn´t show when this part is deleted...😕

[marblo]

no need to answer.... I solved it! I guess i got blinded by looking to hard..

[cgraz]

well in case anyone ever runs across this with the same problem, the error message you received is letting you know there is something wrong with your query. It should be

$query = "select * from shops where name like '%$name%'";

Cgraz

[bliss322]

you can also receive the error message in the instance that no records were returned; so, you can throw a '@' in front of the 'mysql_fetch_assoc($result)'. doesn't solve the issue so much as it supressess the error message.