I do not know why you want a table name like that but you need indentifier quotes (backticks) for it to work.
You need quotes or else it will considered a comment.
$maketemp = "CREATE TABLE `#temp1` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `date` varchar(50), `csc` varchar(50), `effectedareas` varchar(50), `agent` varchar(50), PRIMARY KEY (`id`) ) COLLATE = 'utf8_general_ci' ";
Please refrain from using
mysql_* functions, they are deprecated. Click here.