Graham

I have come across a little PHP problem that I can seem to resolve, I know we discussed it in the course, however for the life of me I cant get it to work, I hope you can help.

The problem is I want to skip the first line of an array.

The Code:

$qr1=mysql_query("select * from news order by timestamps DESC LIMIT 3") or die("Error : " . mysql_error());
while($rs1=mysql_fetch_array($qr1))
{
?>

  <div id="boxtitle">
           <div id="boxtiteleft"></div>
           <div id="boxtitecenter">
           <div class="titlebox"><h1><a href="newsdetail.php?id=<? echo $rs1[Nid]; ?>"><? echo $rs1['Title'];  ?></a></h1></div>
           </div>
           <div id="boxtiteright"></div>
     </div>          
<div id="contentbody">
           <div class="contentbody">
           <div id="picleft">
           <img src="img/sm.gif?>" width="104" height="116" class="border">
           </div>
           <div id="contentright">
<div class="time"><? echo $rs1['Time'];  ?>, <? echo $rs1['Date'];  ?></div>
<? echo $rs1['Summary'];   ?><br><div id="readmorewhite"><a href="newsdetail.php?id=<? echo $rs1[Nid]; ?>">read more</a></div>
</div>
</div>
</div>
<br clear="all">
<?
}
?>


Playing the Devil's advocate, I'm afraid, I don't see an array there that's suitable for skipping over.   The only array in an associative one.

HOWEVER ... I think you may want to skip over the first result.  If that's the case ... first option:

$rs1=mysql_fetch_array($qr1); # Skip first result
while($rs1=mysql_fetch_array($qr1))

or second option - change the limit clause to:

LIMIT 1,2



That LIMIT option worked a treat.. Many thanks.

---