Select Limit Where

Discussion in 'PHP' started by lektrikpuke, Feb 23, 2008.

0
  1. #1
    $query = "SELECT * FROM tbl_name".
    //" LIMIT $offset, $rowsPerPage".
    " WHERE column1 LIKE '%".$keywords[$i]."%'".
    " OR column2 LIKE '%".$keywords[$i]."%'" .
    " OR column3 LIKE '%".$keywords[$i]."%'" .
    " OR column4 LIKE '%".$keywords[$i]."%'" .
    " OR column5 LIKE '%".$keywords[$i]."%'" .
    " OR column6 LIKE '%".$keywords[$i]."%'" .
    " OR column7 LIKE '%".$keywords[$i]."%'" .
    " OR column8 LIKE '%".$keywords[$i]."%'" .
    " OR column9 LIKE '%".$keywords[$i]."%'" .
    " OR column10 LIKE '%".$keywords[$i]."%'" .
    " ORDER BY column1";

    I have a working search (of sorts) that uses the above code. I have been trying to implement pagination into the results, and when I uncomment the line " LIMIT $offset, $rowsPerPage"., I receive an error message. Note: $offset and $rowsPerPage are declared and initialized.

    Any help please?
     
    lektrikpuke, Feb 23, 2008 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    The LIMIT should go at the very end of the query.
     
    nico_swd, Feb 23, 2008 IP
  3. lektrikpuke

    lektrikpuke Well-Known Member

    Messages:
    297
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #3
    Figured it out. Put LIMIT at the end of the query. Thanks any way. =)
     
    lektrikpuke, Feb 23, 2008 IP
  4. lektrikpuke

    lektrikpuke Well-Known Member

    Messages:
    297
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #4
    Thanks nico_swd, just figured it out. I wish I'd just posted it earlier. I've dabbled with it (I won't say how long, just trust me, it was a period of time) for a while.
     
    lektrikpuke, Feb 23, 2008 IP