[SOLVED] How do you read the last row in table

[adi5402]

I have a table with 500 products how do i pick up the last row

 

I know you can order it by using this

 

i can also get the number of rows using some code but is there a way we can just directly read the last entry

 

$sql = 'SELECT * FROM `products` ORDER BY `products`.`book_Id` ASC LIMIT 0, 30 ';

[Mchl]

$sql = 'SELECT * FROM `products` ORDER BY `products`.`book_Id` DESC LIMIT 1';

[adi5402]

cheers