Skip first result of array

[dachshund]

Hi,

 

I have the following code but I want to skip the very first result (or row) as I already have that echoed in a different format above.

$sql = "SELECT * FROM content WHERE `live` LIKE '0' AND `date` >= SUBDATE(CURRENT_DATE, 1) ORDER BY `views` DESC LIMIT 40";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){

Thanks

[Barand]

$sql = "SELECT * FROM content WHERE `live` LIKE '0' AND `date` >= SUBDATE(CURRENT_DATE, 1) ORDER BY `views` DESC LIMIT 40";

$result=mysql_query($sql);

$rows = mysql_fetch_array($result);

   // echo in format A

while($rows=mysql_fetch_array($result)){

  //  echo in format B

}

[requinix]

If you already got the data earlier then why do you need another query? Can't you run just this query once, get the first row, output it the special way, and output the rest normally?