Help with User Update MySQL

[Anon]

I've been on this a while, but I can't figure it out so here hoping that someone will be able to spot what's wrong.

The user submits the information on a previous form that get this document.

$City being one of the fields data to update.
$Handle being the users name in the table where the $City is supposed to be updated.

Thanks in advance.

Stuart

<?php

$db = mysql_connect("localhost", "domain", "password");
mysql_select_db("database",$db);

$result = mysql_query("SELECT * FROM tablename WHERE Handle LIKE '$Handle'",$db);

if ($myrow = mysql_fetch_array($result)) {

do {

mysql_query = ("UPDATE database SET tablename WHERE City LIKE '$City'");

printf ("ok");

} while ($myrow = mysql_fetch_array($result));

} else {

printf ("It didn't work!");
}

?>

[Anon]

Hi,

The update query is incorrect, it should be :

mysql_query("UPDATE tablename SET col = 'value' WHERE City Like '$City", $db);