DB Search problem

[NZ_Kiwis]

I want to display 30 results but how can i set where it starts?? ie: if there where 120 results i want to show them as 120,119,117 but starting at $start and $start being say...90

$result3 = mysql_query ("SELECT * From news order by id desc limit 30");
while ($row3 = mysql_fetch_array($result3)) {

How can I do this?

[Shaped]

limit 0,30

im sure thats all u need to get last 30, try also "ASC LIMIT 0,30" as i dont know how your auto increments are set up.

[thorpe]

SELECT * FROM news ORDER BY id DESC LIMIT 90,30

[NZ_Kiwis]

I have this code,
$replies = 1094
$totalstart = 1064

I have my results to start at 1064 and go to the end! however it's running 30 down to 1...

what is wrong?

$result = mysql_query ("SELECT COUNT(*) From news");
$row = mysql_fetch_array($result);
$replies =  $row[0];

if ($start == "") {
$start = "30";
}

echo $replies;
echo "<br>";

$totalstart = $replies - $start;
echo $totalstart;
echo "<br>";

$result3 = mysql_query ("SELECT * From news order by id desc limit $totalstart,30");
while ($row3 = mysql_fetch_array($result3)) {