MySQL TRUNCATE TABLE in PHP just will not work

[jdowey]

for some reason I can not truncate my table, I am at a lost, can any one help me and tell me

what I am doing wrong?  this is my code.

 

<?php

$host="mysql";

$username="******";

$password="*******";

$database="webhistory";

$table="webhistory";

 

$connection = mysql_connect("$host", "$username", "$password") or die ("Unable to connect to server");

mysql_select_db("$database") or die ("Unable to select database");

$sql = "TRUNCATE TABLE `$table`";

mysql_query($sql);

echo "Table Deleted";

mysql_close($connection);

?>

[fenway]

why not check mysql_error()?