"Wilbert Enserink" <[EMAIL PROTECTED]> wrote:
> 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
Do `create fulltext index idxft on gallery (productname,productnumber)`
> $query="SELECT * FROM gallery LEFT JOIN designers ON
> (designers.designersID=gallery.designersID) WHERE MATCH
> (gallery.productname, gallery.productnumber) AGAINST
> ('%$search_string%')";
... and RTFM.
--
./ premax
./ [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
