Querie sorting and listing

[TheShaftUK]

Hi i am quering a database for the highest priced items and it i am trying to list them 5 at a time. I can do this by the limit 5. I can calculate how many nexts i need but when i click next, how do i list from where it left off.

Is that clear?

Thanks
Jules

[dopey]

along the lines of

$i_want_to_start_from = 15;

$query = "SELECT * FROM prices ORDER BY price DESC LIMIT $i_want_to_start_from,5"

$result = mysql_query($query) or die('oops..'.mysql_error());

Cheers,
Andy.