Page 1 of 1

Searching MySQL Database Using PHP form

Posted: Sat Nov 16, 2002 2:52 pm
by brianw84
hello its me again (i posted the topic below this one) now that i got my record insert to work (thanks again by the way) i need to figure out a way to search all 29 collums. i have read the other forum topics on this subject but they all tend to require the user to specify the which colum to search in. I on the other hand am wondering if there is any way to to set up one text feild to search all the colums in the table and desplay the entire row in which the value was found in.
any help would be greatly appreciated.

Posted: Sat Nov 16, 2002 10:59 pm
by volka
take a look at the MySQL FULLTEXT feature
you may include as many fields as you like to the index

Fulltext Feature

Posted: Sun Nov 17, 2002 8:25 am
by brianw84
I have looked at that and thought about it, but the problem is that i have allready made the table and it has 29 columns, so i would have to make it all over again to utilize the full text component.

Posted: Sun Nov 17, 2002 8:43 am
by volka
you should read more carefully ;)
...at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. For large datasets, it will be much faster to load your data into a table that has no FULLTEXT index, then create the index with ALTER TABLE (or CREATE INDEX).

I read that..

Posted: Sun Nov 17, 2002 12:21 pm
by brianw84
I tride that but you can only make 16 columns fulltext, if u try the whole 29 it dosnt work.
* Allso how do you ad a column?