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

Reply via email to