Added: March/19/2009 at 4:09pm | IP Logged

Hi Chris and everyone,

I was wondering if we can do a user search, based on a drop down (or similar) filtering for like Last Name, Email, Username, etc. etc. on the admin/default.asp page.

At the moment there's on one search field (name="Keyword") and we can only add/remove fields to search in on the

MYSQL="SELECT " & tbl_label_users & ".* FROM " & tbl_label_users & " WHERE ((First_Name = '" & Keyword & "') ..........

line.

Ideally, I'd like to have the filtered search field options (First name, last name etc) plus the comparison options (LIKE, =, ==, >=, etc etc.).

Now,

1st) Is this ever possible withoyt compromising anything on the "users/default.asp" page,

2nd) How Can I do this?

I will appreciate any help at this point.

Thx

Added: March/19/2009 at 8:57pm | IP Logged

1.) Make a copy of the users/default.asp  make the changes there.. then you effect nothing...

2.) to tell you how I'd have to spend many many hours actually doing it. It's nothing easy to explain and I do not support things of this nature so you would have to figure it all out.

It's all very doable.. basic (asp/database/sql) work..