Retreiving Data from a Database <--- Basic issue!

[npsari]

I have a Table (in my database) which consists of 3 Colombs

 

Title:

Story:

Author:

 

I know that if the Title is only 1 word, I use this code to retreive Data:

 

SELECT * from $Tablename where (Title ='Word') 

 

However, what if the tittle is more than One word (With spaces)...

Example: "The story of a brave man"

 

How can the code match ANY of the words in the Title

[Orio]

SELECT * FROM $Tablename WHERE Title LIKE '%Word%'

 

This will match every title that contains the word "Word"

 

Orio.

[npsari]

Thanks

................

 

What if the Title has spaces?

 

Example:

The story of a brave man

 

What will the code be?

[Orio]

What do you mean? I think you mean this:

 

SELECT * FROM $Tablename WHERE Title LIKE '%The story of a brave man%'

 

This will match every title that has "The story of a brave man" in it.

[npsari]

Hey, sorry if i confused you!

 

I want the code to match any of the words

 

So, if someone searched for "brave man" only (Not the whole exact tittle)

 

He still gets the same result

[genericnumber1]

$query = "SELECT * FROM $Tablename WHERE Title LIKE '%{$word}%'";

 

this will search for $word in $Tablename.

[npsari]

So, can $word be more than one word

 

Can it be two words separated by spaces?????

[genericnumber1]

yes

 

$word = "chocolate"; would match "chocolate cake", "chocolate biscuits with gravy", "dry chocolate biscuits", etc

 

$word = "chocolate biscuits"; would match "chocolate biscuits with gravy", "dry chocolate biscuits", etc

 

etc...

[npsari]

Thank you

 

that is what i was looking for

 

good info