help with mysql

[addie]

hello ppl
lest say i have some records in table, how i get total number of them with script, and how i remove them all in once ?

[GameMusic]

SELECT COUNT(*) FROM table

DELETE FROM table

Sorry if I'm misunderstanding your question.

[addie]

it will not work
anyone know how it works with loops getting total number ?

[Sharif]

Are you trying to display the total number of rows/records in your table? Try this:

$sql = "SELECT * FROM table";
$query = mysql_query($sql) or die(mysql_error());
$total = mysql_num_rows($query);

Then to display the total, simply:

echo 'There is a total of ' . $total . ' records in the table.';

or

echo $table;

[addie]

ok thankjs for reply i have been testing script like this before but i dont know why i get error:
PHP Notice: Undefined variable: result in C:\web\test\index.php on line 36 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\web\test\index.php on line 36

[BadMojo78]

Originally posted by addie
ok thankjs for reply i have been testing script like this before but i dont know why i get error:
PHP Notice: Undefined variable: result in C:\web\test\index.php on line 36 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\web\test\index.php on line 36

The notice you get is in my opinion not important. You can deactivate those notices in php.ini.
The warning sais, that your sql-statement is not correct. perhaps a wrong written column or table name???
Ciao, Badmojo