mydsmbr

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]