1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Search Problem

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

0
  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