Thread: change the order of search fields in the extended search

How to change the order of search fields in the extended search form and change default show/hide values for search fields?
Go to your MySQL administration page (like phpMyAdmin). Select your database. Select "ProfilesDesc" table. Here you can modify search_order and search_hide fields.

search_order - order of the search criteria, you can modify this field to move search criteria up or down in the extended search form. You can place numbers in this field that will be sorted in ascending order.

search_hide values:
0 - this search criteria is shown by default.
1 - this search criteria is hidden by default.

Works like a charm.

I'm just trying to locate where to hide the relationship feild on the extended search form. Is it located somewhere else?

Hi, can someone be more specific in how to edit the search_order field? (instructions please).

How do I edit the field in the database?

Thanks in advance