query syntax error?

For this line of code:

$queryW = "UPDATE customer_dbase SET " . $column . "=" . $update . " WHERE index_no LIKE '%" . $ref_no . "%'";
$resultW = mysql_query($queryW);
{
die("<br>" . mysql_errno() . ": " . mysql_error() . "<br>");
}

I get the following SQL error:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE index_no LIKE '%3%'' at line 1

anyone see the problem? thanks.

Try using

$queryW = "UPDATE customer_dbase SET " . $column . "=" . $update . " WHERE index_no = '" . $ref_no . "';";

Something's wrong with your $update variable -- it may not be set correctly, or if it's a string, it needs to have single quotes around it like $ref_no.

Something's wrong with your $update variable -- it may not be set correctly, or if it's a string, it needs to have single quotes around it like $ref_no.


$update is a string, so you were exactly right about having single quotes around it....thanks! :thumbsup: