My Searching Engine, help!!

dominant

I want to create my search engine, a form that a user inputs a name (string) and it searches all the rows of a field (Text, or Varchar)

Any idea?

Wynder

Using?? Database, I assume? You can use the LIKE operator or, with MySQL, the wildcards are %, so if you had a record that was "Test123" searching for "Test%" would match.

dominant

For example

Select title from Books where Author='%$author%'

Is that right?

Wynder

Select title from Books where Author='%$author%'

For best results use:

"SELECT title FROM Books WHERE Author='%" . $author . "%'"

dominant

I observed that works if i put

"SELECT title FROM Books WHERE Author LIKE '%" . $author . "%'"

dominant

Now i want to search on 2 or more columns simultaneously for the same word (different tables).

How could i do that?

DigitalExpl0it

Originally posted by dominant
Now i want to search on 2 or more columns simultaneously for the same word (different tables).

How could i do that?

you will need to spilt the search string with exploit() then do a array and loop... so basicly you search each word, keyword, phrase...

then you can add things to your SQL statement like

"SELECT title FROM Books WHERE Author LIKE '%".$author."%' AND Description LIKE '%".$author."%'"