[RESOLVED] Update problem

Tezread

Im trying to perform an update procedure but come up with the following 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 'accreditingbody ='test' briefdesc = 'test' aimedat = 'test' l: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 'accreditingbody ='test' briefdesc = 'test' aimedat = 'test' l

Here is my code:

$password = "";
$connection = @mysql_connect($host, $root, $password)
or die ("Couldn't connect to server.");
$database = "courses";
$db = @mysql_select_db($database, $connection)
or die ("Couldn't select database.");

if (isset($_POST['Submit'])) {
//insert the values entered into the courseentry form into the database

$coursename = $POST['coursename'];
$accreditingbody = $POST['accreditingbody'];
$briefdesc = $POST['briefdesc'];
$aimedat = $POST['aimedat'];
$level1 = $POST['level1'];
$level2 = $POST['level2'];
$level3 = $POST['level3'];
$elearning = $POST['elearning'];
$facetoface = $POST['facetoface'];
$blended = $POST['blended'];
$elearningtime = $POST['elearningtime'];
$facetofacetime = $POST['facetofacetime'];
$blendedtime = $_POST['blendedtime'];

$sql = "UPDATE trainingtopics SET

coursename = '$coursename'
accreditingbody ='$accreditingbody'
briefdesc = '$briefdesc'
aimedat = '$aimedat'
level1 = '$level1'
level2 = '$level2'
level3 = '$level3'
elearning = '$elearning'
facetoface = '$facetoface'
blended = '$blended'
elearningtime = '$elearningtime'
facetime = '$facetofacetime'
blendedtime = '$blendedtime'
)"
or die (mysql_error());

//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

if(!$res) {
echo mysql_error().":".mysql_error()."";
return 0;

//$result = $db->query($sql);
echo $sql;
}
}

echo $coursename;
echo $briefdesc;

mrhappiness

read http://dev.mysql.com/doc/mysql/en/update.html

(hint: look for the commas)

Tezread

I see now- ive followed instructions in the manual but there is still an error message stating an 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 ')' at line 16

for reference line 16 is:

$briefdesc = $_POST['briefdesc'];

mrhappiness

that mysql error messages refers to the mysql command not the php script (where from should mysql know at which line in the php script you started the command?

it's line 16 of your INSERT that is erroneous.
change

or die (mysql_error());

or die (mysql_error().'<hr /><pre>'.$sql.'</pre>');

Tezread

ok im getting the same error message though after that change in code:

<?php
$user = "root";
$host = "localhost";
$password = "";
$connection = @mysql_connect($host, $root, $password)
or die ("Couldn't connect to server.");
$database = "courses";
$db = @mysql_select_db($database, $connection)
or die ("Couldn't select database.");

if (isset($_POST['Submit'])) {
//insert the values entered into the courseentry form into the database

$sql = "UPDATE trainingtopics SET

coursename = '$coursename',
accreditingbody ='$accreditingbody',
briefdesc = '$briefdesc',
aimedat = '$aimedat',
level1 = '$level1',
level2 = '$level2',
level3 = '$level3',
elearning = '$elearning',
facetoface = '$facetoface',
blended = '$blended',
elearningtime = '$elearningtime',
facetime = '$facetofacetime',
blendedtime = '$blendedtime',
)"

or die (mysql_error().'<hr /><pre>'.$sql.'</pre>');
//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

if(!$res) {
echo mysql_error().":".mysql_error()."";
return 0;

//$result = $db->query($sql);
echo $sql;
}
}