Query works in mysql CLI but not in PHP

[leoric80]

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!

[leoric80]

Oh and no errors are returned either, quite confused by all this!

[DavidAM]

Print out the error message to see why:

 

if (! mysql_query(...)) echo mysql_error();

[leoric80]

Ah this was me being an idiot! It was an issue with my foreach statement, thanks anyway