Drop, Create and Select for Temporary Table

[NigeB]

I am having problems with the code listed below, I keep having a parse error reported on the line pertaining to DROP TABLE. Am I missing something fundamental or is it a bigger problem? Any help is appreciated.

Nigel

___________________________________________________

<?
$db = mysql_connect(&quot;Server&quot;, &quot;User&quot;, &quot;Password&quot;

mysql_select_db(&quot;Database&quot;, $db);

DROP TABLE IF EXISTS seedtmp1, $db;
?>

<?
$db = mysql_connect(&quot;Server&quot;, &quot;User&quot;, &quot;Password&quot;

mysql_select_db(&quot;Database&quot;, $db);

CREATE TEMPORARY TABLE seedtmp1
SELECT Ttimes.TRN, Teams.Team, Ttimes.Fastest_Time, Venues.Date, Venues.Venue
FROM Teams
LEFT JOIN Ttimes ON Teams.TRN = Ttimes.TRN
LEFT JOIN Venues ON Ttimes.Tournament_ID = Venues.Tournament_ID
&quot;, $db);


?>