Real Quick Question

Anon

when I do a select for example:

select * table WHERE book LIKE '%dogs obedience training%'

this selects book fields containing the value of " dogs obedience training " and others like "dogs obedience training volume1"
"dogs obedience training volume2" and everything else that contains the 3 words "dogs obedience training"

However, I need the select to search for individual words...

for example:

when I select
"dogs obedience training"

I want values such as "dogs", or "obedience" to come up as well..

How do I do it?

Anon

i have a *.wps file but i dont know what this extension (wps) is and please tell me how to open this file.
i will appreciate a prompt reply.
thank you.
antonio

Anon

select * table WHERE (book LIKE '%dogs%' OR book LIKE '%obedience%' OR book LIKE '%training%')

I think that should do it...

Jack

Anon

oops, I forgot to mention that the LIKE '%something%' is a variable.. it's chosen by the users, so I won't know what it is exactly..

something like book LIKE '%$book%'.

so your way won't work out.

Anon

sure it will work.

you just need to build the statement up in PHP before passing it through to sql.

Use explore() to split the input search term up into separate words, use a loop to create an OR clause for each word, and append it to the sql query string.

It'll take a little bit of php programming, but that's what you gots to do..

Anon

Ok, thanks!

Anon

Hi,

I'm kind of stuck here...

After I used something like

$explodedbook = explode(" ",$book);
for ($i=0;$i<count($explodedbook);$i++)
{
have no idea what to do to include the OR command for the SELECT line..
}

help?

Thanks

Anon

This is a stupid way I have... since very likely the value I have will be within 4 words, I can do the if statement 5 times.. like this:

$explodemodel = explode(" ",$model);

for ($i=0;$i<count($explodemodel);$i++)
{
$expmodels[$i]= $explodemodel[$i];
}
if (count($explodemodel) = 0) {

$models = 'model LIKE ' .'%explodemodel[0]%';
}
elseif (count($explodemodel) = 1) {

$models = 'model LIKE ' .'%explodemodel[0] . 'OR model LIKE' .'%explodemodel[1]%';
}

then SELECT * WHERE $models

isn't this stupid? help me out please!