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), NAME of the DVD VARCHAR(30)"


$result_createtemptable mysql_query($query_createTemporaryTable ,$dbhandle );
                                                            
$query_insertintotable "INSERT INTO everything (ArtistName, NAME of the DVD) VALUES ('RIHANNA', 'SHAWSHANK')";

$result_insertintotable mysql_query($query_insertintotable ,$dbhandle);

$query_selecttemptable "SELECT ArtistName,NAME of the DVD FROM temp";

$result_selecttemptable mysql_query$query_selecttemptable,$dbhandle);

$row_selecttemptable mysql_fetch_array($result_selecttemptable$dbhandle);

while(
$row_selecttemptable mysql_fetch_array($result_selecttemptable$dbhandle)){
      echo 
$row_selecttemptable
      
or die mysql_error("Try Again");
  }


?>
Error:Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /studhome/0/1104107/public_html/mysql_connect.php on line 33

I am seriously stuck. I dont know what I am missing.

Thanks for any help provided.