Raging on this sql error

[fus10n]

Cant find a reason for this not to work

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM urls ORDER BY id DESC LIMIT 0,10' at line 1

PHP Code:

<?php
$con = mysql_connect("localhost","***","***");
mysql_select_db("dubstep3_project1");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query("DELETE * FROM urls ORDER BY id DESC LIMIT 0,10") 
or die(mysql_error()); 
?>

Any help is greatly appreciated


Also in-cases its not obvious enough trying to delete top 10 row...i tried the TOP function and that also does not work.

[tangoforce]

Not sure about the "ORDER BY id DESC LIMIT 0,10" bit, but you definitely don't need the * there in the sql. You're not selecting anything or updating one single item - you're deleting a whole row so mysql doesn't expect you to tell it what to delete.

Remove the * and see what happens.

If that doesn't work, you'll need to select 10 records using the "ORDER BY id DESC LIMIT 0,10" and then delete them.

[fus10n]

Okay, removing the * gave me this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10' at line 1.


How would I go about deleting the rows after i select them??

[Fou-Lu]

LIMIT is the literal number to delete. Its impossible to delete a range of 0 to 10. Just use 10.
Here's a link to the delete syntax as well: http://dev.mysql.com/doc/refman/5.0/en/delete.html

[tangoforce]

Originally Posted by fus10n

How would I go about deleting the rows after i select them??

Just to clarify something, you're not selecting any rows when using the delete command. You're simply telling it to delete things based on a condition. There is no selection involved.