Search Problem

Discussion in 'Databases' started by ottodo, Aug 17, 2006.

  1. #1
    Hello,

    I have problem in doing my search script,
    I want to search more than one field in same table but with just one text box.
    Does anyone here know how I can perform this search?
    And if search result were so bit how can I slit the result to pages.
    Thanks
     
    ottodo, Aug 17, 2006 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    use the like

    search against as many tables you want as in:

    Where productName like '%box%' OR .... like '%box%' OR..... you can search as many tables/fields as you want.

    displaying the results - just run through your recordset and echo the results :)
     
    ccoonen, Aug 17, 2006 IP
  3. ottodo

    ottodo Guest

    Messages:
    2,055
    Likes Received:
    70
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thx for info dude :)
     
    ottodo, Aug 18, 2006 IP
  4. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #4
    not a problem!
     
    ccoonen, Aug 21, 2006 IP