search wildcard %

Discussion in 'PHP' started by MyVodaFone, Jun 12, 2010.

0
  1. #1
    My DB search string example 
    WHERE title like \"%" . $dvd_search . "%\"";
    Code (markup):
    Works fine I guess, but it must be an exact match although its not case sensitive, does anyone here know of how to search for misspelt words ?
     
    MyVodaFone, Jun 12, 2010 IP
  2. roopajyothi

    roopajyothi Active Member

    Messages:
    1,302
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    80
    #2
    No you need to built a algorithm for it!
    You can use a drop Down search list or you can use a Suggestor Class or even you can use a Spelling correction class which is available in PHP Classes
    If you're Pro think using Google Search API
     
    roopajyothi, Jun 12, 2010 IP