Mysql syntax error:

[rofl90]

Heres my error:

 

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 'SET name='Charlie Kirk', title='Senior Designer', about='Hi there, my name is Ch' at line 1

 

and the coding;

 

$name = addslashes($_POST['name']);
$title = addslashes($_POST['title']);
$about = addslashes($_POST['about']);
$phone = addslashes($_POST['phone']);
$email = addslashes($_POST['email']);
$skype = addslashes($_POST['skype']);
$world = addslashes($_POST['world']);
$house = addslashes($_POST['house']);

$query = "UPDATE $myuser SET name='$name', title='$title', about='$about', phone='$phone', email='$email', skype='$skype', world='$world', house='$house'";
mysql_query($query) or die(mysql_error());

echo "Updated";
echo $myuser;
echo "'s profile!";

[rofl90]

bump

[conker87]

You need a WHERE clause, it doesn't know what rows to update.

 

$query = "UPDATE $myuser SET name='$name', title='$title', about='$about', phone='$phone', email='$email', skype='$skype', world='$world', house='$house' WHERE `column` = 'blah'";

[PFMaBiSmAd]

It is highly likely that $myuser is empty and the query is - UPDATE SET name='$name', ...

 

Echo your $query variable to make sure it contains what you expect.

[revraz]

Yep, two things wrong, the tablename and no WHERE function.

[kenrbnsn]

The no "where" wouldn't cause a MySQL syntax error, but the OP probably wouldn't get the results he was looking for.

 

Ken