toothpick007

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 '178723'' at line 1 UPDATE BTECL31113 SET FirstName='Sony' , LastName='Bouachanh' , GroupCode='A' , Unit1='D' , Unit2='M' , Unit3=' ' , Unit6=' ' , Unit14='P' , Unit20='M' , Unit27=' ' , Unit28='D' , Unit42='M' , Unit10=' ' , Unit11=' ' , Unit12=' ' , Unit13=' ' , Unit1454=' ' , Unit15=' ' , Unit16= ' , Unit17=' ' , Unit18=' ' WHERE P_Id='178723' OMG its ok I found it I was missing a ' on unit 16 thank you so much you have been a great help and thank you so much for your time and your tips ....

ok ive done it i sent the wrong code oops ... <? $con = mysql_connect('localhost', 'lccstude_progre', '*******'); $db= "lccstude_pro"; if (! $con) die("Couldn't connect to MySQL"); mysql_select_db($db , $con) or die("Couldn't open $db: ".mysql_error()); $ud_P_Id = mysql_real_escape_string( $_POST['ud_P_Id']); $ud_LastName = mysql_real_escape_string( $_POST['ud_LastName']); $ud_FirstName = mysql_real_escape_string( $_POST['ud_FirstName']); $ud_GroupCode = mysql_real_escape_string($_POST['ud_GroupCode']); $ud_P_Unit1 = mysql_real_escape_string($_POST['ud_P_Unit1']); $ud_P_Unit2 = mysql_real_escape_string($_POST['ud_P_Unit2']); $ud_P_Unit3 = mysql_real_escape_string($_POST['ud_P_Unit3']); $ud_P_Unit6 = mysql_real_escape_string($_POST['ud_P_Unit6']); $ud_P_Unit14 = mysql_real_escape_string($_POST['ud_P_Unit14']); $ud_P_Unit20 = mysql_real_escape_string($_POST['ud_P_Unit20']); $ud_P_Unit27 = mysql_real_escape_string($_POST['ud_P_Unit27']); $ud_P_Unit28 = mysql_real_escape_string($_POST['ud_P_Unit28']); $ud_P_Unit42 = mysql_real_escape_string($_POST['ud_P_Unit42']); $ud_P_Unit10 = mysql_real_escape_string($_POST['ud_P_Unit10']); $ud_P_Unit11 = mysql_real_escape_string($_POST['ud_P_Unit11']); $ud_P_Unit12 = mysql_real_escape_string($_POST['ud_P_Unit12']); $ud_P_Unit13 = mysql_real_escape_string($_POST['ud_P_Unit13']); $ud_P_Unit1454 = mysql_real_escape_string($_POST['ud_P_Unit1454']); $ud_P_Unit15 = mysql_real_escape_string($_POST['ud_P_Unit15']); $ud_P_Unit16 = mysql_real_escape_string($_POST['ud_P_Unit16']); $ud_P_Unit17 = mysql_real_escape_string($_POST['ud_P_Unit17']); $ud_P_Unit18 = mysql_real_escape_string($_POST['ud_P_Unit18']); if (!mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id' ")) { echo mysql_error(); }; echo "Record Updated"; mysql_close($con); ?> However im still getting the same 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 '178723'' at line 1

I am yes here is all the code on that page but I cant seem to find any quotes :-? <? $ud_P_Id = $_POST['ud_P_Id']; $ud_LastName = $_POST['ud_LastName']; $ud_FirstName = $_POST['ud_FirstName']; $ud_GroupCode=$_POST['ud_GroupCode']; $ud_P_Unit1=$_POST['ud_P_Unit1']; $ud_P_Unit2=$_POST['ud_P_Unit2']; $ud_P_Unit3=$_POST['ud_P_Unit3']; $ud_P_Unit6=$_POST['ud_P_Unit6']; $ud_P_Unit14=$_POST['ud_P_Unit14']; $ud_P_Unit20=$_POST['ud_P_Unit20']; $ud_P_Unit27=$_POST['ud_P_Unit27']; $ud_P_Unit28=$_POST['ud_P_Unit28']; $ud_P_Unit42=$_POST['ud_P_Unit42']; $ud_P_Unit10=$_POST['ud_P_Unit10']; $ud_P_Unit11=$_POST['ud_P_Unit11']; $ud_P_Unit12=$_POST['ud_P_Unit12']; $ud_P_Unit13=$_POST['ud_P_Unit13']; $ud_P_Unit1454=$_POST['ud_P_Unit1454']; $ud_P_Unit15=$_POST['ud_P_Unit15']; $ud_P_Unit16=$_POST['ud_P_Unit16']; $ud_P_Unit17=$_POST['ud_P_Unit17']; $ud_P_Unit18=$_POST['ud_P_Unit18']; $con = mysql_connect('localhost', 'lccstude_progre', '********'); $db= "lccstude_pro"; if (! $con) die("Couldn't connect to MySQL"); mysql_select_db($db , $con) or die("Couldn't open $db: ".mysql_error()); if (!mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id' ")) { echo mysql_error(); }; echo "Record Updated"; mysql_close($con); ?> <? echo $ud_P_Id ?> <? echo $ud_LastName ?>; <? echo $ud_FirstName ?>; <? echo $ud_GroupCode?>; <? echo $ud_P_Unit1 ?>; <? echo $ud_P_Unit2 ?>; <? echo $ud_P_Unit3 ?>; <? echo $ud_P_Unit6 ?>; <? echo $ud_P_Unit14 ?>; <? echo $ud_P_Unit20 ?>; <? echo $ud_P_Unit27 ?>; <? echo $ud_P_Unit28 ?>; <? echo $ud_P_Unit42 ?>; <? echo $ud_P_Unit10 ?>; <? echo $ud_P_Unit11 ?>; <? echo $ud_P_Unit12 ?>; <? echo $ud_P_Unit13 ?>; <? echo $ud_P_Unit1454 ?>; <? echo $ud_P_Unit15 ?>; <? echo $ud_P_Unit16 ?>; <? echo $ud_P_Unit17 ?>; <? echo $ud_P_Unit18 ?>;

Yea im going to fix it all just getting the basic stuff out the way first .... I now have a error this is what gets returned .... 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 '178723'' at line 1Record Updated 178723Bouachanh; Sony; A; D; M; ; ; P; M; ; D; M; ; ; ; ; ; ; ; ; ;

Where would i put it in here ???? if (! $con) die("Couldn't connect to MySQL"); mysql_select_db($db , $con) or die("Couldn't open $db: ".mysql_error()); mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id'"); echo "Record Updated"; mysql_close($con);

Im not getting a error at all its just not writting to the database for some strange reason ....

mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id'"); Because for some reason its not writting to my database !!!!!

@Muddy I have got the die ... And nothing happens i get the echo statement on the page and i had other echos to see if the information is coming across which it is but its just not writting to the database for some strange reason ..... @Reqinix Done that but no change still not writing to the database ....

I have written some code to past information from one page to a diffrent page however all the variables are sent over but they are not writting to the database could anyone help me out please .... $ud_P_Id = $_POST['ud_P_Id']; $ud_LastName = $_POST['ud_LastName']; $ud_FirstName = $_POST['ud_FirstName']; $ud_GroupCode=$_POST['ud_GroupCode']; $ud_P_Unit1=$_POST['ud_P_Unit1']; $ud_P_Unit2=$_POST['ud_P_Unit2']; $ud_P_Unit3=$_POST['ud_P_Unit3']; $ud_P_Unit6=$_POST['ud_P_Unit6']; $ud_P_Unit14=$_POST['ud_P_Unit14']; $ud_P_Unit20=$_POST['ud_P_Unit20']; $ud_P_Unit27=$_POST['ud_P_Unit27']; $ud_P_Unit28=$_POST['ud_P_Unit28']; $ud_P_Unit42=$_POST['ud_P_Unit42']; $ud_P_Unit10=$_POST['ud_P_Unit10']; $ud_P_Unit11=$_POST['ud_P_Unit11']; $ud_P_Unit12=$_POST['ud_P_Unit12']; $ud_P_Unit13=$_POST['ud_P_Unit13']; $ud_P_Unit1454=$_POST['ud_P_Unit1454']; $ud_P_Unit15=$_POST['ud_P_Unit15']; $ud_P_Unit16=$_POST['ud_P_Unit16']; $ud_P_Unit17=$_POST['ud_P_Unit17']; $ud_P_Unit18=$_POST['ud_P_Unit18']; $con = mysql_connect('localhost', 'lccstude_progre', '********'); $db= "lccstude_pro"; if (! $con) die("Couldn't connect to MySQL"); mysql_select_db($db , $con) or die("Couldn't open $db: ".mysql_error()); mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id'"); echo "Record Updated"; mysql_close($con); Please any help would be great