PHP
-
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 'order set custid='4',catid='1', proid='2',quantity='14',totalbill='1400', ' at line 1] insert into order set custid='$custid',catid='$catid', proid='$proid',quantity='$quantity',totalbill='$totalbill', deldate='$var_date',orderstatus='$orderstatus kindly explain me this 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 'order set custid='4',catid='1', proid='2',quantity='14',totalbill='1400', ' at line 1] insert into order set custid='$custid',catid='$catid', proid='$proid',quantity='$quantity',totalbill='$totalbill', deldate='$var_date',orderstatus='$orderstatus kindly explain me this error
Your query is wrong. For your requirement, you should use
UPDATEstatement but you're usingINSERT. And there's a single quote (') missing at end of the query.insert into UPDATE order set custid='$custid',catid='$catid',
proid='$proid',quantity='$quantity',totalbill='$totalbill',
deldate='$var_date',orderstatus='$orderstatus**'**Probably you should learn MySQL very well before doing project works. Here more than couple of ways to learn anything in Internet. Education Needed[^]
thatraja
Code converters | Education Needed No thanks, I am all stocked up. - Luc Pattyn When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute