Limit

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

    Limit

    If I have the page in such a record:

    $sql="SELECT id, byid, fwd, unread, archive, toid, text FROM inbox
    WHERE ((toid='".getuid_sid($sid)."' AND fwd='0')
    OR (fwd='".getuid_sid($sid)."')) AND archive='0'
    ORDER BY !unread,id DESC LIMIT $limit_start, $items_per_page
    ";

    I put LIMIT which will concern only the text? Sorry my english is bad

    #2
    ???? if you take out
    LIMIT $limit_start, $items_per_page
    it will show everything in 1 page
    otherwize you are limiting it a number of items

    Comment

    Working...
    X