Read the last Row

[scraff]

I have tried everything, and cant get my code to display the last row in my database on its own.
I can show the First row, First and Second, First Second and Third etc. but not the last row on its own (or last two or three rows)
This code is to show the last few entrys in a table.

My code displays all rows, or all rows with a certain colum when = somthing...

mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");

$query = "SELECT * FROM ListProducts WHERE cat1 != ''";
//or $query = "SELECT * FROM ListProducts WHERE cat1 = ''somthing special";

$query_result_handle = mysql_query ($query) 

//$num_of_rows = mysql_num_rows ($query_result_handle) ; 

for ($count = 1; $row = mysql_fetch_row ($query_result_handle); ++$count) 
 { 

print "<a href=\"$link.php?from=$table&table=$row[1]&cat1=$row[0]\">$row[0]</a><br> "; 

 }

Can someone please help??

Thanks

[scraff]

And may i add...
so maybe the code can read any given row, say row 22.
Or a random row between the first row and the last.

🙂