Am 15.04.2011 18:34, schrieb Gary: > Michael > > I'm sorry, I should have removed this code for the post, but this code is > part of a "honey pot". There is no 'address' input visible, it is used so > if a spam bot enters information into this field, it kills the form. Humans > cannot enter anything into this field.
but why somewhere middle in the code instead making clean verifications at the begin? > ""Again, I see no reason you could not call last_insert_id() after the > first insert and use that value explicitly in the second. > "" > > I'm not sure I undertand this, could you explain a little further for me <?php mysql_query("insert into table1 (field1, field2) values ('value1', 'value2')", $conn); $id = mysql_insert_id($conn); mysql_query("insert into table2 (ref_id, data) values (" . $id . ", 'yourdata')", $conn); ?> as long you never use the insert-id from the AI i wonder how there could be anything out of sync because there never can be anything in sync
signature.asc
Description: OpenPGP digital signature