Updating database

[abramfas]

<?php  
$objConnect = mysql_connect("localhost","root","") or  die(mysql_error());  
$objDB = mysql_select_db("databasetable");  
$strSQL = "UPDATE admin SET ";  
$strSQL .=",surname = '".$_POST["surname"]."' ";  
$strSQL .=",othernames = '".$_POST["othernames"]."' ";  
$strSQL .=",gender = '".$_POST["gender"]."' ";  
$strSQL .=",username = '".$_POST["username"]."' ";  
$strSQL .=",password = '".$_POST["password"]."' ";  
$strSQL .="WHERE id = '".$_GET["id"]."' ";  
$objQuery = mysql_query($strSQL);  
if($objQuery)  
{  
echo "Save completed.";  
}  
else  
{  
echo "Error Save [".$strSQL."]";  
}  
mysql_close($objConnect);  
?>

I have this code to update tables in the database but it is giving me some errors. can any one please help me find where the problem is? Thanks

[Rabbit]

We need to know what the error message says.

[alexsts2013]

try to replace

 $strSQL = "UPDATE admin SET ";  
$strSQL .=",surname = '".

with following

 $strSQL = "UPDATE admin SET ";  
$strSQL .="surname = '".

[alexsts2013]

Also replace

"' "

with following

"'"

Except last one ($_POST["password"]."' "; ) because on front of where clause you will need space like " where"; right now if you look at print of your $strSQL you will see some pretty ugly string.
Use my suggestion and it will look much better and fix syntax errors as well.

[abramfas]

Hi Alexsts,

I have corrected all the things you said but am still having the same errors...

Error Save [UPDATE admin SET surname = 'adam'othernames = 'apple'gender = 'male'username = 'admin'password = 'password'WHERE id = '7']

[alexsts2013]

try this:

$strSQL = "UPDATE admin SET ";  
$strSQL .="surname = '".$_POST["surname"]."'";  
$strSQL .=",othernames = '".$_POST["othernames"]."'";  
$strSQL .=",gender = '".$_POST["gender"]."' ";  
$strSQL .=",username = '".$_POST["username"]."'";  
$strSQL .=",password = '".$_POST["password"]."' ";  
$strSQL .="WHERE id = '".$_GET["id"]."' ";

You removed to much from your string.
I told you to remove single comma and empty spaces, not all commas.
Let me know how new string will do.
By the way your ID is it string or integer?
If it is integer than following should be insted:

$strSQL .="WHERE id = ".$_GET["id"];