tags:

views:

32

answers:

0

Here is a set of queries that are being executed all in succession (via a foreach php loop). Following the query is the mysql_insert_id, supposedly showing a successful query.

INSERT INTO item_relationship (table1, item1_ID, table2, item2_ID, notes) VALUES ('df_dimension','2','df_dimension','1',''): inserted ID: 123 INSERT INTO item_relationship (table1, item1_ID, table2, item2_ID, notes) VALUES ('df_dimension','2','es_dimension','2',''): inserted ID: 124 INSERT INTO item_relationship (table1, item1_ID, table2, item2_ID, notes) VALUES ('df_dimension','2','indicator','1','note 22'): inserted ID: 125

However, the query where 'table1' and 'table2' have the same name are not showing up in the table when I do a select *. The only key on this table is "ID", which is auto-incremented.

Has anybody seen something like this before?