Database Search

[Night4554]

So, Here's what I've got:

$query .= " AND '$_POST[advsearch]' IN (search_words)";

Now let's say that advsearch is "bmx". search_words is a column in the database with the following data:

"bmx, freestyle, backflip"

It should return it, right? But no, it will only return it where the search_words is "bmx".

Where's my logic error?

[mystrymaster]

Use like and wildcards if you want a match on one of the things in the list

SELECT whatever FROM tablenamehere where advsearch Like '%$_POST[advsearch]%'

That will return it if it has a match in there.

[ahundiak]

mystrymaster is correct. You need to use LIKE.

Your logic error is that you have your IN clause backwards. The column name goes to the left and the values go to the right. So what you tried to do just won't work.

$ids = '1,2,3';
SELECT FROM table WHERE id IN ($ids)