nullpoint81 Posted January 14, 2012 Share Posted January 14, 2012 My question is basically this: If I'm building a submission form - which places info into my DB via a mySQL query (INSERT INTO) - is there also a way to reference the id that it is creating? The form is set to just dump raw data into a database - each submission enters data into at least 8 DB tables which are all tied together by an $id row in each table. My query references those $id rows in each table to build a query. After each query is completed, a unique url (which is stated by the submitter in the form of /example/someotherword/) is generated. I need to find a way to place some sort of script within a page that displays the results based on each $id. So, lets say that the url is clicked, it would take you to a page that displays the results - but only does so based on the reference to that urls unique $id within the table. I'll provide code once I get home, but if you guys have any ideas that would be great. Link to comment https://forums.phpfreaks.com/topic/254995-auto-generating-php-pages-in-relation-to-auto_increment/ Share on other sites More sharing options...
gizmola Posted January 14, 2012 Share Posted January 14, 2012 If you're asking how you get the id from an insert.... mysql_insert_id. You call this after a successful insert, and from there, you can do other inserts, or use the id as a get parameter you provide when you build a link to the display page. If you have some other question, please clarify. Link to comment https://forums.phpfreaks.com/topic/254995-auto-generating-php-pages-in-relation-to-auto_increment/#findComment-1307503 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.