Im trying to create some temporary tables in mysql using php

by

I do not know why you want a table name like that but you need indentifier quotes (backticks) for it to work.

`#temp1`

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.

Browse More Popular Posts

Leave a Comment