Commit

bbuk · April 15th, 2010, 12:35 PM

Hi would anybody be able to help me, i try to Edit a record in my database and the following error occurs..

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 '@webcase.com username = bbradshaw password = password WHERE ' at line 4

That is my commit script below, any help would be much appreciated!

<?php
require 'db.inc.php';

$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or
die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));
?>
<html>
<head>
<title>Commit</title>
</head>
<body>
<?php
switch ($_GET['action']) {
case 'add':
switch ($_GET['type']) {
case 'projectmember':
$query = 'INSERT INTO
projectmember
(firstname, surname, email, username, password)
VALUES
("' . $_POST['firstname'] . '",
"' . $_POST['surname'] . '",
"' . $_POST['email'] . '",
"' . $_POST['username'] . '",
"' . $_POST['password'] . '")';
break;
}
break;
case 'edit':
switch ($_GET['type']) {
case 'projectmember':
$query = 'UPDATE projectmember SET
firstname = "' . $_POST['firstname'] . '",
surname = ' . $_POST['surname'] . ',
email = ' . $_POST['email'] . '
username = ' . $_POST['username'] . '
password = ' . $_POST['password'] . '
WHERE
memberID = ' . $_POST[''];
break;
}
break;
}

if (isset($query)) {
$result = mysql_query($query, $db) or die(mysql_error($db));
}
?>
<p>Done!</p>
</body>
</html>

bbuk · April 15th, 2010, 12:45 PM

the table in question is below, and the data inside it.

$query = 'CREATE TABLE IF NOT EXISTS projectmember (
memberID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
firstname VARCHAR(40) NOT NULL DEFAULT "",
surname VARCHAR(40) NOT NULL DEFAULT "",
email VARCHAR(40) NOT NULL DEFAULT "",
username VARCHAR(40) NOT NULL DEFAULT "",
password VARCHAR(40) NOT NULL DEFAULT "",

PRIMARY KEY (memberID)
)
ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

--------------------------------------------------------------------------

$query = 'INSERT INTO projectmember(memberID, firstname, surname, email, username, password)
VALUES (1,"Bernard", "Bradshaw", "[email protected]", "bbradshaw", "password")';