Zeradin Posted August 15, 2008 Share Posted August 15, 2008 Hey, so I want to have a form that people fill out and then I want to send the title and some other info to an SQL table and then i want to take all of the data and save it as an xml file with the name of the automatically generated SQL id. For instance someone submits a review or something and the title goes to the sql table where the id auto-increments and applies it to the title. and then i need that value back to the php so i can save the data in an xml file itemid.xml thanks! Link to comment https://forums.phpfreaks.com/topic/119827-solved-getting-immediate-return-from-sql-insert/ Share on other sites More sharing options...
JasonLewis Posted August 15, 2008 Share Posted August 15, 2008 Just use the form data along with mysql_insert_id(). Good luck. Link to comment https://forums.phpfreaks.com/topic/119827-solved-getting-immediate-return-from-sql-insert/#findComment-617336 Share on other sites More sharing options...
Zeradin Posted August 15, 2008 Author Share Posted August 15, 2008 wow that's fing easy Link to comment https://forums.phpfreaks.com/topic/119827-solved-getting-immediate-return-from-sql-insert/#findComment-617348 Share on other sites More sharing options...
lonewolf217 Posted August 15, 2008 Share Posted August 15, 2008 not to thread hijack, but is there a similar way to do this with ms_sql ? I have read about scope_identity() but I cannot figure out how to use it Link to comment https://forums.phpfreaks.com/topic/119827-solved-getting-immediate-return-from-sql-insert/#findComment-617411 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.