hi all,
i'm new to this list. currently busy with mysql. I'm having troubles with
the query string below. The part MATCH results in an error: Can't find
FULLTEXT index matching the column list
however it looks like i'm doing the query according to the manual. Anybody
has any clue what's going wrong here?
$query="SELECT * FROM gallery LEFT JOIN designers ON
(designers.designersID=gallery.designersID) WHERE MATCH
(gallery.productname, gallery.productnumber) AGAINST ('%$search_string%')";
thx. Regards
Wilbert
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
[EMAIL PROTECTED]
-------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
