get last 10 record of a table

[Anon]

How can i get last 10 records of mysql table can anyone give me a sample code?

[Anon]

You probably sort the rows in your table, either in descending or ascending order.

All you need to do is change the order and get the first 10.

example:
mysql_query("SELECT * FROM names ORDER BY name DESC");

the above query should be changed to:
mysql_query("SELECT * FROM names ORDER BY name ASC LIMIT 10");

You can also run another query to count the number of rows, and then fetch the last 10 rows.

example:
$sql = mysql_fetch_assoc(mysql_query("SELECT COUNT(*) AS counter FROM names"));

mysql_query("SELECT * FROM names ORDER BY name DESC LIMIT " . ($sql['counter'] - 10) . ", 10");

[Anon]

I did not get it completly,

lets say i have a table called ds_search.

Now, i want to print the fields title, lid & url of last 10 records of ds_search. how i do this? can one give the complite script to do this, please.

[Anon]

otherwise, please what is wrong here, attemted to pull last 10 records of a table ds_search.

<?
$connection = mysql_connect("myserver", "myusername", "mypass");
$query = "SELECT * FROM ds_search ORDER BY $lid DESC LIMIT 10";
$result = mysql_db_query($database, $query, $connection);

echo "<li> $lid <a href=$url>$title</a>";

mysql_close($connection);
?>

[Anon]

i got it guys, dont worry, and thanks everyone for help! love this community