help in limit

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    help in limit

    hey friends.. i want to display 10 gbook msg... i am not getting how to set limit for it..
    PHP Code:
    $scraps =   mysql_fetch_array(mysql_query("SELECT gbowner, gbsigner, gbmsg, dtime, id FROM ibwf_gbook WHERE gbowner='".$who."' ORDER BY dtime DESC LIMIT 10")); 

    #2
    PHP Code:
    $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); 

    Comment


      #3
      try something like this
      Code:
      $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";
      Last edited by Loony; 23.01.10, 19:34.
      Creator of
      Epix.Mobi

      Keep an Eye on us Big things coming soon!!!!
      Need something for your site hit me up here

      http://coding-talk.com/forum/main-fo...r-your-wapsite

      Comment

      Working...
      X