[SOLVED] deleting first entries in db

[contra10]

if i wanted to delete the first 10 entries in my db

i.e. there are 20 latest entries and i want to delete the first 10 that were entered.

 

how could i do that...does it invilve using the max function

 

[sasa]

DELETE FROM table_name WHERE 1 ORDER BY fiel_name LIMIT10

[Cosizzle]

DELETE FROM table_name LIMIT 10

 

edit: Use sasa method, bit more safe

[Technocracy]

<?php
mysql_query("
	DELETE FROM `table`
	ORDER BY `auto_incremental_key` ASC
	LIMIT 10
");
?>

 

Presumably that's what you mean.

 

EDIT: too slow but yeah.

[contra10]

ye thats it...thnks