How to DROP tables

timbarnett

Still can't make tables temporary using the keyword TEMPORARY (no one have any ideas why not?), so want to drop the the tables and the end of the function.

Where does the DROP table go here? Any help appreciated. PHP...

// now dump all data into tempst.
}

$get_results_sql=" SELECT * from ".$temptable2."  group by photoid";
if ($s) { $get_results_sql=$get_results_sql." limit $s, 12"; } else { $get_results_sql=$get_results_sql." limit 0,12"; }
$get_results=DBqueryArr($get_results_sql);
return($get_results);
}

I need to drop tables before return...

DBquery("DROP TABLE ".$temptable1); // drop temptable1

DBquery("DROP TABLE ".$temptable2); // drop temptable2

Adding the above before returns no results, and not executed after return.

bernouli

shouldn't that suppose to be like this
DBquery("DROP TABLE $temptable1");

timbarnett

I think the syntax is OK, as I can drop the tables if I put it before the return statement, only I get no results, so its where to put those two lines...?

timbarnett

I was able to DROP the tables here but the code is very modular with 3 modules using these tables, so dropping them here created problems elswhere. The solution was not to drop the tables but to use temporary tables, which I was having trouble with but have sorted - see other post.

Sxooter

Are these temporary tables? If you declare them as temp tables they should be dropped on session exit,

I.e.

create temp table bubba (word varchar, id int);