[PHP-DB] mysql searching with fulltext indexing

[Bevan Christians]

Hi Listies

I have a question

Is there any to query a mysql table to get it to return the field
names that it currently
has marked as Fulltext Indexes?

I need to build a searching engine, there are 60 tables being
searched, i have created the fulltext indexes on all tables required
and i currently have the tables in an array
now what i want to do is use a for loop to loop through each table
find its releveant FTS Indexes and then based on the field name use it
in a MATCH() AGAINST() query and then return all the results in xml?

Anyone have any idea how i can query the tables in order to get it to
return the indexes

Thanks in advance (hoping you guys can help)

Re: [PHP-DB] mysql searching with fulltext indexing

[Bevan Christians]

thanks muchly for the help guys :D

On 24/05/06, Chris [EMAIL PROTECTED] wrote:

 Anyone have any idea how i can query the tables in order to get it to
 return the indexes

show indexes from tablename;

http://dev.mysql.com/doc/refman/5.0/en/show-index.html

--
Postgresql  php tutorials
http://www.designmagick.com/