[theRemix]

if i want to insert into two tables very similar data, the first table has an id which is the primary key and auto_increment, the second has id that is only primary key, but how do i set the second table's id, to be identical to the first table's autoincremented id ?

[theRemix]

k i found it, thanks theRemix!

http://dev.mysql.com...-insert-id.html
if anyone is as noobish as me...

INSERT INTO tbl (auto,text) VALUES(NULL,'text');
INSERT INTO tbl2 (id,text) VALUES(LAST_INSERT_ID(),'text');

[theRemix]

is

$query1 = "DELETE FROM products WHERE id = '$id' AND cid = '$cid'";
$query2 = "DELETE FROM thumbsProducts WHERE id = '$id' AND cid = '$cid'";

the same as

$query1 = "DELETE FROM products,thumbsProducts WHERE id = '$id' AND cid = '$cid'";

?