Usually when I use ASP with Access or MS SQL I am able to do the following:
'add info to tbl1
'then grab the primary key ID to use for insert into tbl2
'then i can use the variable theUserID to update a different table.
However MySql always takes me to the row BEFORE the last one, and Ive even tried creating a new recordset object and just going straight to rs.movelast and gettin ID, which seemed to work at first but its messing my data up somehow..is there and easy fix for this or easy way to achieve this? using ASP and MySQL?
210 points to whoever can help me out (all i have)