Pieduriens Posted February 19, 2013 Report Share Posted February 19, 2013 Labvakar. Galīgi netieku gudrs. Vēlos izpildīt kveriju caur php: Kverijs: $vouc = 'xxx'; $sql = " SET FOREIGN_KEY_CHECKS=0; INSERT INTO salesrule (name)VALUES('$vouc'); SET FOREIGN_KEY_CHECKS=1; "; mysql_query($sql) or die (mysql_error()); Caur phpmyadmin SQL kverijs izpildās. Caur PHP saņemu kļūdu: 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 'INSERT INTO salesrule (name)VALUES('xxx'); SET FOREIGN_KEY_CHECKS=1' at line 2 Ticu, ka risinājums ir elementāri elementārs, taču zinu, ka svaiga acs to ieraudzīs. Paldies :) Quote Link to comment Share on other sites More sharing options...
aaxc Posted February 19, 2013 Report Share Posted February 19, 2013 Tu pameegjinaaji izpildiit 3 dazhaadus querijus? Quote Link to comment Share on other sites More sharing options...
Pieduriens Posted February 19, 2013 Author Report Share Posted February 19, 2013 Tu pameegjinaaji izpildiit 3 dazhaadus querijus? Fantastika! Paldies par hint ;) Quote Link to comment Share on other sites More sharing options...
Kavacky Posted February 20, 2013 Report Share Posted February 20, 2013 Multi query. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.