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 '('KAvin','ka...@d.con','df','7777777777' WHERE id='20')' at line 1
can I Know why I am getting this error, code was entered below <?php $id=$_POST['id']; $name=$_POST['name']; $email=$_POST['email']; $password=$_POST['password']; $mobile=$_POST['mobile']; $con=@mysql_connect("localhost","root","") or die(mysql_error()); $db=@mysql_select_db("click",$con)or die(mysql_error()); $str="UPDATE kncet SET('$name','$email','$password','$mobile' WHERE id='$id')"; $res=@mysql_query($str)or die(mysql_error()); if($res>=0) { echo "Successful"; } else{ echo(" <strong> <p>Insertion delivery failed...try later! and Also enter email has been used already.</p> </strong>"); } ?>*===================================* *-By Kavinraj. S.I* *Website:* Kavinraj S.I <http://sikavinraj.tk> *Group: LORE Group [ Open TECH ] <http://www.loregroup.in>* Phone: 7811811767 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines