On Tue, Oct 14, 2014 at 1:20 PM, Shrinivasan T <tshriniva...@gmail.com> wrote:
> > $str="UPDATE kncet SET('$name','$email','$password','$mobile' WHERE > > id='$id')"; > > print the entire query to test it. > > echo $str; > > and execute the same in the mysql shell. > > > -- > Regards, > T.Shrinivasan > > UPDATE kncet SET('20', 'Kavin','Female', 'k...@gmail.com','sdfsdg','8124455131' WHERE name='Kavin') 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 '('20', 'Kavin','Female', 'k...@gmail.com','sdfsdg','8124455131' WHERE name='Kavi' at line 1 I had try this code $sql="UPDATE kncet SET id='$id', name='$name', sex='$sex', email='$email', password='$password', mobile='$mobile' WHERE name='$name'"; but it shows Query was empty _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines