Hi
i m using php and mysql..I am inserting the data into the table and straight after that i want to grab the primary key for use. how do i do that

Code:

$SQL = "INSERT INTO table (name,addressType,suburb,state,postcode,contactName,number_of_standart_stb,number_of_IQ_stb) VALUES ('".$_POST['name']."','".$_POST['addressType']."','".$_POST['Suburb']."','".$_POST['State']."','".$_POST['Postcode']."','".$_POST['contactName']."','".$_POST['standardSTB']."','".$_POST['iqstb']."')";
now after inserting this record i want to use the primary key( ID) ...how do i retreive that straight away?