try something like this:
[php:1:f49acaf7d6]<?php
$conn = mysql_connect(\"localhost\",\"***\",\"***\");
mysql_select_db(\"*database_here*\", $conn);
$result = mysql_query(\"SELECT * FROM `xdcc`\", $conn);
while ($row=mysql_fetch_array($result)) {
mysql_query(\"DELETE FROM `xdcc` WHERE `id`=\'\".$row[\'id\'].\"\'\", $conn);
}
mysql_close($conn);
?>[/php:1:f49acaf7d6]
for a start it doesnt know which database to work with. also maybe the id\'s in the table dont start with 1 and end with however many records there are in that table.
[php:1:f49acaf7d6]<?php
$result = mysql_query(\"SELECT * FROM xdcc\", mysql_connect(\"localhost\",\"***\",\"***\"));
$countDB = mysql_num_rows($result);
echo $countDB.\" Rows <BR>\";
$tempno = \"1\";
while ($tempno <= $countDB){
$query = \"DELETE * FROM xdcc WHERE id = \'$tempno\'\";
$result = mysql_query($query);
$tempno++;
}
?>[/php:1:f49acaf7d6]
and just to be a prick you should learn about for() http://php.net/for
[php:1:f49acaf7d6]<?php
for ($tempno=1; $tempno <= $countDB; $tempno++) {
$query = \"DELETE * FROM xdcc WHERE id = \'$tempno\'\";
$result = mysql_query($query);
}
?>[/php:1:f49acaf7d6]