leoric80 Posted June 28, 2013 Share Posted June 28, 2013 Hi, sorry for being a complete noob but I am running the following query in PHP and it is not updating the database. mysql_query('INSERT INTO 1_outbox (destno, student_id, message) SELECT p1contact_no, contact_id_internal, "poo" FROM 1_contacts WHERE contact_id_internal=100;'); If I run the same command in the CLI it updates the database as expected.. mysql> INSERT INTO 1_outbox (destno, student_id, message) SELECT p1contact_no, contact_id_internal, "poo" FROM 1_contacts WHERE contact_id_internal=100; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 This is not a permissions issue as other insert statements within the same form work fine, have I got my PHP syntax wrong by any chance? Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/279669-query-works-in-mysql-cli-but-not-in-php/ Share on other sites More sharing options...
leoric80 Posted June 28, 2013 Author Share Posted June 28, 2013 Oh and no errors are returned either, quite confused by all this! Quote Link to comment https://forums.phpfreaks.com/topic/279669-query-works-in-mysql-cli-but-not-in-php/#findComment-1438418 Share on other sites More sharing options...
Solution DavidAM Posted June 28, 2013 Solution Share Posted June 28, 2013 Print out the error message to see why: if (! mysql_query(...)) echo mysql_error(); Quote Link to comment https://forums.phpfreaks.com/topic/279669-query-works-in-mysql-cli-but-not-in-php/#findComment-1438419 Share on other sites More sharing options...
leoric80 Posted June 28, 2013 Author Share Posted June 28, 2013 Ah this was me being an idiot! It was an issue with my foreach statement, thanks anyway Quote Link to comment https://forums.phpfreaks.com/topic/279669-query-works-in-mysql-cli-but-not-in-php/#findComment-1438425 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.