PHP/MYSQL

[syco]

<?php$imageurl = $_REQUEST['imageurl'];$email = $_REQUEST['email'];$age = $_REQUEST['age'];$show = $_REQUEST['show'];$showa = $_REQUEST['showa'];if ($age && $email) {$query = mysql_query("UPDATE znetworking_members SET email = '$email', show = '$show', imageurl = '$imageurl', age = '$age', showa = '$showa' WHERE id = '$msqlid'");echo mysql_error();}?>

No matter what it will always say that show or showa are bad...

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 'show = '1', imageurl = 'http://i210.photobucket.com/album' at line 1

If someone can please help that would be nice

[Ingolme]

It's possibly because you're putting quotes around values that are supposed to be numeric.

[justsomeguy]

"show" is a reserved word in SQL, you need to either change the column name, or use backquotes when you refer to it:

$query = mysql_query("UPDATE znetworking_members SET email = '$email', `show` = '$show', imageurl = '$imageurl', age = '$age', showa = '$showa' WHERE id = '$msqlid'");

[syco]

Thanks justsomeguy it worked, i just decided to rename it