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 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. 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. . . 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 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
Archived
This topic is now archived and is closed to further replies.