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?