[Resolved] all rows minus 1'st row found?

move3rd

How can I output all rows found by a sql query execpt the first row found?

Why do I want to do that?
I'm modifing cube cart and I would like to display the full details of the first product within a catagory and just links to all other products in that catagory.

I have copied the section of code that displays the catagorys and set the first sql stament to "LIMIT 1". Now I just need to set the secound Sql stament to display all execpt the first row.

bubblenut

Why do the LIMIT 1?

$sql="SELECT * FROM cart WHERE condition=$value";
$res=mysql_query($sql);

$row=mysql_fetch_array($res);

//do stuff with the first row here

while($row=mysql_fetch_array($res)) {
  //handle the rest of the rows here
}

If you absolutely have to do them as two seperate queries you could use [man]mysql_data_seek()[/man] but you should try to use as few queries as possible as db interation is generally one of the primary bottlenecks in a web script

HTH
Bubble

nemonoman

OR just start with second row using a LIMIT statement:
$sql="SELECT * FROM cart WHERE condition=$value LIMIT 2,
999999999999999";

move3rd

Originally posted by nemonoman
OR just start with second row using a LIMIT statement:
$sql="SELECT * FROM cart WHERE condition=$value LIMIT 2,
999999999999999";

Think thats the most suitable way to do it.

bubblenut, Thanks for the sugestion. I think I will have to use 2 queries for what I want to do.