empty numerous tables ?? HOW?

[sys7em]

I heed to empty numerous tables in one of my databases ..and this is what I do ...

<?
 include("util.php");

   $q = 'DELETE from `aksesoari`;'

    . ' DELETE from `cables`;'
    . ' DELETE from `camers`;'
    . ' DELETE from `cartridge`;'

    . ' DELETE from `casecpu`;'

    . ' DELETE from `cddvd`;'

    . ' DELETE from `copiers`;'

    . ' DELETE from `cpu`;'

    . ' DELETE from `fan`;'

    . ' DELETE from `fdd`;'

    . ' DELETE from `hdd`;'

    . ' DELETE from `keyboard`;'

    . ' DELETE from `mainboard`;'

    . ' DELETE from `modem`;'

    . ' DELETE from `monitor`;'

    . ' DELETE from `mouse`;'

    . ' DELETE from `multicards`;'

    . ' DELETE from `multimedia`;'

    . ' DELETE from `network`;'

    . ' DELETE from `notebook`;'

    . ' DELETE from `printers`;'

    . ' DELETE from `ram`;'

    . ' DELETE from `scaner`;'

    . ' DELETE from `software`;'

    . ' DELETE from `sound`;'

    . ' DELETE from `ups`;'

     . ' DELETE from `video`;'
    . ' ';
	 mysql_query($q);
 echo $q ."<br>\n";
?>

The script is executed succsefully ...but It doesn't work ..the tables still have data in them ...what am I doing wrong ??

Thanks in advance ....

[nunomira]

hi,

I guess you need to execute those DELETE statemets in different querys

or

you need to use a different syntax: multi-table syntax.

When deleting everything you may use a WHERE that's always true:

... WHERE 1=1;