help in limit

[icedroplet1987]

hey friends.. i want to display 10 gbook msg... i am not getting how to set limit for it..

$scraps =   mysql_fetch_array(mysql_query("SELECT gbowner, gbsigner, gbmsg, dtime, id FROM ibwf_gbook WHERE gbowner='".$who."' ORDER BY dtime DESC LIMIT 10")); 

[icedroplet1987]

$scraps =   mysql_fetch_array(mysql_query("SELECT gbowner, gbsigner, gbmsg, dtime, id FROM ibwf_gbook WHERE gbowner='".$who."' ORDER BY dtime DESC LIMIT 1, 5"));

$whose = getnick_uid($scraps[1]);
  $sign23 = htmlspecialchars($scraps[2]);
  $sign23 = parsepm($scraps[2], $sid); 

[Loony]

try something like this

$sql = "select * from ibwf_gbook WHERE gbowner='$who' ORDER BY dtime DESC LIMIT 10";
  $gbook = mysql_query($sql);
  while($l=mysql_fetch_array($gbook))
  {
    $gbowner = $l['gbowner'];
    $gbsigner = $l['gbsigner'];
$gbmsg = $l['gbmsg'];
$dtime = $l['dtime'];
$id = $l['id'];
  }
echo "$dbsigner($dtime)<br/> ";
echo "$gbmsg";