WatsonN Posted August 14, 2011 Share Posted August 14, 2011 I have a DB INSERT in a script and that works just fine, The problem is that I can't figure out how to get the ID for that entry I just added. I tried using a combonation of SELECT and mysql_fetch_row and a few other varaitions but I can't get to get the data I need. $PostedID = mysql_query("SELECT ID FROM Playlists WHERE `UID` = '{$_SESSION['ID']}' & `Title` = '{$Title}' & `Description` = '{$Description}' & `delete` = '0'"); $POSTid = mysql_fetch_row($PostedID); Here is the INSERT that I used mysql_query("INSERT INTO `Playlists` (`UID`, `Title`, `Description`, `date`, `Author`) VALUES ('{$_SESSION['ID']}', '{$Title}', '{$Description}', NOW(), '{$_SESSION['UID']}')") or die(mysql_error()); I know the SESSION variables look backwards but I promise they aren't I'm just not sure what it would take to get this to return correctly Quote Link to comment https://forums.phpfreaks.com/topic/244757-return-the-id-of-the-previous-insert/ Share on other sites More sharing options...
trq Posted August 14, 2011 Share Posted August 14, 2011 mysql_insert_id. Quote Link to comment https://forums.phpfreaks.com/topic/244757-return-the-id-of-the-previous-insert/#findComment-1257134 Share on other sites More sharing options...
WatsonN Posted August 14, 2011 Author Share Posted August 14, 2011 I knew I was over thinking it. Thank you. I also right after posting realized i used & instead of AND, Getting lazy. . . Quote Link to comment https://forums.phpfreaks.com/topic/244757-return-the-id-of-the-previous-insert/#findComment-1257142 Share on other sites More sharing options...
trq Posted August 14, 2011 Share Posted August 14, 2011 You can use && instead of AND Quote Link to comment https://forums.phpfreaks.com/topic/244757-return-the-id-of-the-previous-insert/#findComment-1257144 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.