mysql insert not working

[brianlange]

I have a mysql insert statement generated with php that is not populating the table.

I've echoed the statement and if I copy and paste into phpmyadmin it works fine.

The result of the mysql_query function is true.

I've emptied the table so there are no primary key conflicts.

I've put the statement in a try catch and it does not display a exception.

What else can I try?

 

Here's the statement

INSERT INTO `wp_term_relationships` (object_id, term_taxonomy_id, term_order) VALUES (1597,83,0)

 

Works absolute fine if I copy and paste into phpmyadmin. Does not populated the table if run through mysql_query

 

[SamT_]

Are you getting any error messages from your PHP page? The query looks correct and you confirmed it by running it in phpMyAdmin. This sounds like a problem with your PHP, paste it here in

 tags and remove your password from mysql_connect().

[ManiacDan]

He means to paste it inside [ code ] tags. 

 

Also, are you sure you're in the right database on the right server?  Your PHPMyAdmin instance is probably running on the local MySQl server, the PHP script could be connecting to another server entirely.

 

-Dan

[brianlange]

echo $insert_term_relationship . '<br /><br />';
    	   $result = mysql_query($insert_term_relationship) or die(mysql_error());
    	   echo $result;

 

The result of my echo statement is what I am copy and pasting into phpmyadmin.

$result is always equal to 1.

[brianlange]

I am on the right server. I am running multiple queries. The first query doesn't enter anything despite returning true from

mysql query. The second one inserts correctly. The table has zero rows before running the script so I'm sure what has been entered.

Losing my mind here 

INSERT INTO `wp_term_relationships` (object_id, term_taxonomy_id, term_order) VALUES (1597,83,0)

INSERT INTO `wp_term_relationships` (object_id, term_taxonomy_id, term_order) VALUES (1597,77,0)

 

 

 

[jcbones]

Are you inserting them with separate calls to mysql_query(), or are you just delimiting them with a semi-colon, and running one mysql_query() ?

[brianlange]

Its within a loop which results in separate calls to mysql_query

[brianlange]

I did a repair table and got the record to insert once. Now its back to not working. Inserting through phpmyadmin works fine.

I guess I'll look into using a different server...

[ManiacDan]

Show the results for SHOW CREATE TABLE on this table. 

 

Did you make sure you only had ONE database and database server?  You're not inserting into test and checking production or anything like that?

 

--Dan