PHP & MySQL: Truncate multiple tables

[TerryR]

I tried to truncate a table but why is it not working? must something wrong in the database query?\[code\]$sql = "TRUNCATE TABLE `table_name`";$result = $connection -> query($sql);\[/code\]Ideally, I want to truncate all tables in one go - is it possible?if you wonder what is inside the class that I use to make the database queries, here is it,\[code\]#connects the database and handling the resultclass __database { protected $connection = null; protected $error = null; #make a connection public function __construct($hostname,$username,$password,$database) { $this -> connection = new mysqli($hostname,$username,$password,$database); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } } ... #performs a query on the database public function query($query) { $result = $this -> connection -> query($query); if($result) { return $result; } else { $this -> error = $this -> connection -> error; return false; } } #display error public function get_error() { return $this -> error; } #closes the database connection when object is destroyed. public function __destruct() { $this -> connection -> close(); }}\[/code\]thanks.edit:below is how I call the db object,\[code\]# the host used to access DBdefine('DB_HOST', 'localhost');# the username used to access DBdefine('DB_USER', 'root');# the password for the usernamedefine('DB_PASS', 'xxx');# the name of your databse define('DB_NAME', 'xxx'); $connection = new __database(DB_HOST,DB_USER,DB_PASS,DB_NAME);\[/code\]