PHP with MySQL

[Recursion]

How would I use a PHP file to clear a Database of ALL tables?

[Tomm]

mysql_select_db("db_name", $mysqlconnectionvar);
mysql_query("DROP TABLE `table_name`;");

[Splinter]

I think the query:

DELETE FROM tablename would suffice but im not sure..

As Toms deletes the table and you seem to want it just to be cleared "/

[Recursion]

I want the Database cleared of all Tables

[Splinter]

then use:
mysql_query("DROP TABLE `table_name`;");
for each table =]

[nets]

To delete everything from the table, but not the actuall table:

TRUNCATE TABLE 'tableName'

To delete the table and the data it contains:

DROP TABLE 'tableName'