[SOLVED] Delete all from a table

[lmhart]

I can not get the following code to work.  If I run the sql statement in the db it will delete all the data but it will not work from the page.  My connection string is fine I just can not get it to delete.

 

<?php
include 'dbc.php'


mysql_query("delete from categories");

include 'redirect_category.php';
?>

[pastcow]

try "truncate table categories" it might also be worth displaying echo(mysql_error()) after it just to see if there is anything going wrong.

[lmhart]

changed to truncate table but still getting the following error

 

Parse error: syntax error, unexpected T_STRING in /home/themarkh/public_html/budget/delete_all_categories.php on line 5

 

[mikesta707]

post code. a syntax error is usually easy to fix

[lmhart]

<?php

include 'dbc.php'

 

 

mysql_query("Truncate table 'categories'");

 

include 'redirect_category.php';

?>

[cags]

Remove the single quotes which you have around the word categories.

[lmhart]

still getting the same error

[cags]

You also don't have a semicolon on the end of include 'dbc.php'

[lmhart]

You also don't have a semicolon on the end of include 'dbc.php'

 

That was it. 

 

Thanks