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.
Searching MySQL Database Using PHP form
Moderator: General Moderators
take a look at the MySQL FULLTEXT feature
you may include as many fields as you like to the index
you may include as many fields as you like to the index
Fulltext Feature
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.
I read that..
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?
* Allso how do you ad a column?