Return the ID of the previous INSERT

[WatsonN]

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

[trq]

mysql_insert_id.

[WatsonN]

I knew I was over thinking it. Thank you.

I also right after posting realized i used & instead of AND, Getting lazy. . .

[trq]

You can use && instead of AND