Jump to content

PHP/MYSQL


syco
 Share

Recommended Posts

<?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

Link to comment
Share on other sites

"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'");

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...