[SOLVED] Skip first result from Query

[skyer2000]

Quick Question,

 

After pulling results from a query, how do you skip the first result?

[cooldude832]

in php you can do

 

http://us2.php.net/manual/en/function.mysql-field-seek.php

 

otherwise you could try and do a LIMIT on a query that chops of row #1

[skyer2000]

I am using PHP, but still can't figure it out. What do you mean by using Limit to chop of row #1?

 

The results will be changing as I add newer ones, so I can't specifically skip a certain 'id'.

[The Little Guy]

$sql = mysqls_query("SELECT * FROM `tableName`");
$i = 0;
while($row = mysql_fetch_array($sql)){
     if($i != 0){
          echo $row['columnName'].'<br />';
     }
     $i++;
}

[skyer2000]

Of course, I never thought to do that, thank you!