I know this might simple for many of you. But I am new and Trying to learn. I want to have a form that searches a database. The form should have a drop down menu that will allow to search different table fields based on the selection. The fields are "lname" and "idnum". So, my drop down menu named "type" should have those two as options. Now next to that I will have a text field called "input" which should will take in the value to search. Now, How do I write a SQL statement that will take the value from the drop down (which will tell what field to search) and the input (the string to search for) and search the table "members" Thanx

Wanna be WebDESIGNER

Check this post

Hope that helps<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Edited by - xlarge on 22 Jul 2003 21:58:56