temporary table

[astaroth]

actually it\'s a newbie question.....

i need to make a table inside a php code...

do i have to write like

$sql=(create temporary table KWTemp type=heap (ID int auto_increment primary key not null, KW varchar(255) not null)\");

 

OR

can i it work without the $sql just

(create temporary tabel ....)

[pallevillesen]

You have to send it to the mysql server using the mysql_query() function..

 

Whether you put the sql statement in a variable first or directly in the mysql_query(\"Select....\"); doesn\'t matter....

 

I prefer the first due to readability.

 

P.