Hey All,
I'm just wondering how any of you would do the following. Any input would be appreciated.
I have two and in some cases 3 tables, lets take the case of two tables, its simpler. These two tables relate using an id field that is set as int unsigned auto_increment. In the same process I wish to add data to table 1 and then use the id just generated in that table, and insert it with another data set into table 2, this way these two tables will be related using this id. How do you guys do this at the moment? I'm looking for different work arounds or one that is very reliable. I hope this explains enough what I am wishing to achieve.
Thanks,
Dave.
