list all in DB, apart from first 2

[joecooper]

Hi, this is the code i am using to loop though the database and display all the entrys apart from the first 2 returned:

 

$query = mysql_query("SELECT * FROM games ORDER BY id DESC");
$i = 1;
while ($row = mysql_fetch_assoc($query)){
     if ($i == 1 || $i == 2){
           //do nothing as these are the 2 featured ones and dont need to be displayed here
     }else{
           //code for the table to display data etc...
     }
}

 

but it never returns anything. if i remove the if statement, it works but displays the first 2 that i dont want to include.

[ranjuvs]

increment the "i" value

 

$query = mysql_query("SELECT * FROM games ORDER BY id DESC");
$i = 1;
while ($row = mysql_fetch_assoc($query)){
     if ($i == 1 || $i == 2){
           //do nothing as these are the 2 featured ones and dont need to be displayed here
     }else{
           //code for the table to display data etc...
     }
$i++;
}

[joecooper]

ah, got it thanks. i did have that but in the wrong place (after the 2 })

 

thanks!