Page 1 of 1

[SOLVED ] Is there any problem with this code??

Posted: Fri Mar 12, 2004 11:22 pm
by dakkonz

Code: Select all

$query = "SELECT * FROM client WHERE MATCH (comName) AGAINST ({$_POSTї'word']})";
            $result1 = @mysql_query ($query);
            $row1 = @mysql_fetch_row($result1);
Can anyone tell me if there is anything wrong with this code??

Posted: Sat Mar 13, 2004 6:17 am
by Pointybeard
Are you saying its not working? Get rid of those @ symbols and see what, if any, errors its throwing.

off the top of my head, it looks ok....if i remember correctly, to use the match thingie, you have to have set that field in the table to "full text" otherwise it wont work. Have a look in the manual.

-PB

Posted: Sat Mar 13, 2004 7:45 am
by dakkonz
thanks a lot.. did not set the field to be FULLTEXT