Hi there, I have an insert query which basically inserts a title to an article in my web site and also inserts the information.
It then needs to insert the picture locations etc on the site, what I wondered if after the insert command whether I can retrieve the id of the insert that i made.. e.g.
---- table = sections ---
- id,title,section ---------
Now when I use the insert command to insert I then need to fetch what the id was from the row that it just entered since it is auto_increment - then I can insert it into sectionid under images.
If that makes sense.
Thanks,
Chris