I know this because the temp table is not deleted after closing the connection. I am using PHPMyAdmin. Any help is appreciated

PHP Code:
<?php
$hostname 
"localhost"
$username "1104107";
$password "r940c1";
$database "db1104107";
//echo '24';

//connection to the database
$dbhandle mysql_connect($hostname$username$password);
$db mysql_select_db($database$dbhandle)
  or die(
"Unable to connect to MySQL");
//echo "Connected to MySQL<br>";

$query_createTemporaryTable "CREATE TEMPORARY TABLE #temp(temp_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
                                                           ArtistName VARCHAR(20), NAMEOfTheDVD VARCHAR(30)"


$result_createtemptable mysql_query($query_createTemporaryTable ,$dbhandle );
                                                            
$query_insertintotable "INSERT INTO temp (ArtistName, NAMEOfTheDVD) VALUES ('R', 'SHAWooSHANK')";

$result_insertintotable mysql_query($query_insertintotable ,$dbhandle) or die(mysql_error());

$query_selecttemptable "SELECT ArtistName,NAMEOfTheDVD FROM temp";

$result_selecttemptable mysql_query$query_selecttemptable,$dbhandle) or die(mysql_error());



while(
$row_selecttemptable mysql_fetch_array($result_selecttemptable)){
      echo 
$row_selecttemptable;
     
  }
 
mysql_close();

?>