PHP and MySQL error :(

[AliBail]

Hi, does anyone know what this error means:

Can't find FULLTEXT index matching the column list

occurs when i try to do:

$thequerystr=mysql_query("SELECT * From content WHERE MATCH (Title,Document,Poster) AGAINST ('$squery')");
if( mysql_num_rows($thequerystr) < 1 ){

so im assuming ive screwed up, but cant seem to find where, as query i am using is as it says on MySQL Documentation at http://www.mysql.com/doc/en/Fulltext_Search.html

Thanks in advance for any assistance you can offer

[wpearsall]

i spose its a Search Script your trying to make?

You could use:

$sql = "Select * From ".$prefix.$table." WHERE $table_Column OR $second_column OR $third_Column LIKE '%$query%'";

% = SQL Wildcard so it will match anything eitherside of it

I could be totally arsed up here but if its what your looking to do, then its your best bet

<edit>

Forgot the . after the " before the $prefix and after the $table before the "

[phpman]

do you have a mysql version of 3.23.23 or greater? did you create the FULLTEXT column?

[AliBail]

Originally posted by phpman
do you have a mysql version of 3.23.23 or greater? did you create the FULLTEXT column?

As u said, i stupidly forgot to create the column

Thanks for help, ppl