long time no see 😉
I'm wanting to insert a record into a table where the id is an autoincrement field and then get the id that was generated back to php so that I can create more data that references that record.
I'm sure this must be fairly easy since it's quite a common task. I've looked into a number of ideas such as sub queries. I also pondered the possibilty of the solution involving mysql_result but I don't think that will be any different from normal query data retrieval as far as this solution goes.
I've had a good search around the forums and haven't found anything relevant. Any thoughts?/Places to looks?
Thanks
-ksandom 🙂
Added note: I meant to say that I noticed that phpMyAdmin returns the id of records created by user statements. This is exactly what I'm trying to achieve. I've had a look through the code, but it looks like it will take quite a while to track down exactly where that happens.
