UPDATE query not working, can u help?

[canoman1]

Can anyone tell me why this fails?

Value is passed from a form, and printing all the variabls shows they are correctly passed.

if(isset($_POST[‘update’]))

(connection to database is here)
$house_number = $_POST[‘house_number’];

$query = “UPDATE asw_users (house_number) VALUES (’$house_number’) WHERE username=’”.$_SESSION[‘username’]."’ ";
mysql_query($query) or die(‘Error, updating query During update proc failed’);

---

it looks simple enough but i cant get it to update the db
any ideas?
ta.

[RaythXC]

$query = "UPDATE asw_users (house_number) VALUES ('$house_number') WHERE username='".$_SESSION['username']."' ";

Should be:

$query = "UPDATE asw_users SET house_number='{$house_number}' WHERE username='{$_SESSION['username']}'";

[canoman1]

Thanks for the help, that works fine for a single value, but how would i write it for say 3 values, using the (‘value1’, ‘value2’, ‘value3’) VALUES (’$value1_posted_from_form’, '$Value2 etc…)

thanks again

[RaythXC]

house_number=’{$house_number}’, value2=’{$Value2}’

[Mariko]

I like the valuable information you be offering to your articles. I can bookmark your www.phphelp.com and feature my children test up right here generally. I am slightly positive they are going to be informed quite a lot of new stuff here than anybody else!