Display SQL Query results but skip first row

[slj90]

I want to display data from a MySQL Table but I want to skip the first row of data.

My code so far displays all the rows:

$result=mysqli_query($con,"SELECT filename FROM images WHERE item_id = '$id'");

if (mysqli_num_rows($result) > 0) {
   
    while($row = mysqli_fetch_assoc($result)) {
		
        echo "<img src='../pictures/items/" . $row[filename] . "' height='200'><br><br>";
}
} else {
    echo "You haven't added any items yet.";
}

What do I need to add to skip the first row?

 

Thanks

Edited October 15, 2015 by slj90

[ginerjm]

$first = true;
while($row = mysqli_fetch_assoc($result))
{
   if ($first)
   {
      $first = false;
       continue;
   }
...
...
...

Edited October 15, 2015 by ginerjm

[mac_gyver]

without an ORDER BY term in your sql statement, there is NO guarantee that any particular row of matching data is going to always be the first row.

 

what characteristic does your data have that identifies what order you want the rows from the query to be in and what identifying characteristic or value is there that you can use to not include the one particular row in the result set?

[ginerjm]

Sorry about my previous post.  For some reason the forum is acting strangely today.  I did not spread my code out like that intentionally.

[hansford]

I wish all questions were like this - oh yeah and I got to them first

[benanamen]

Can someone tell me under what circumstances you would want to skip the first row of your query result? I cant for the life of me think of one.

 

Beuler?......Beuler?......Beuler?......