Unable to clear table

[siric]

Hi,

 

I am inserting temporary values into a table for use on a resultset.  Once I am done I want to clear the data out of the table and have used both

 

//clear tempbiz table
$sqlClearBiz = "DELETE from tempbiz";
$resClearBiz = mysql_query($sqlClearBiz);

 

and

 

//clear tempbiz table
$sqlClearBiz = "TRUNCATE tempbiz";
$resClearBiz = mysql_query($sqlClearBiz);

 

but neither work.  However, I run the command in an SQl client, it works.

 

What can I check??

[cags]

Try...

 

$sqlClearBiz = "TRUNCATE tempbiz";
$resClearBiz = mysql_query($sqlClearBiz) or die(mysql_error());

To see if it is reporting an error with the request.

[fenway]

FYI, if you ever had any other records linked to this table by UID, you'd better clear them out, or reset the auto-increment value, or you'll be sorry.