Darkness1427 Posted June 8, 2011 Share Posted June 8, 2011 hey, new to forums so hi everyone. im trying to create a system in php ad mysql where users can add details about properties, but to break down the table i have two tables one that is about the overall property and a table for individual rooms, the rooms are linked to the main table with a propertyID my question is, is it possible to retrive the property ID at the same time as a new property is being inserted? the property id is automatically assigned by mysql on insertion and is an auto increment field. so it will be the last row in the table if that helps. Hope someone can help, Nate p.s if it would help if i posted the table structures just holla and ill upload them. Quote Link to comment https://forums.phpfreaks.com/topic/238748-insert-and-select/ Share on other sites More sharing options...
suresh_kamrushi Posted June 8, 2011 Share Posted June 8, 2011 Hi, You can get it by using function mysql_insert_id(); Quote Link to comment https://forums.phpfreaks.com/topic/238748-insert-and-select/#findComment-1226818 Share on other sites More sharing options...
Darkness1427 Posted June 8, 2011 Author Share Posted June 8, 2011 thanks for the quick reply ill try this straight away Quote Link to comment https://forums.phpfreaks.com/topic/238748-insert-and-select/#findComment-1226829 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.