I have a single search field ' agent_name' in a form which is a dropdown field of data based on the concatonation of 2 fields: reg_fname and reg_lname
When I do the SELECT Query though I'm getting a bit mixed up.....
The data from reg_fname & reg_lname does not go into fullname
Also for obvious reasons I cant' compare what is selected in the field agent_name with fullname.....
But I don't know how else to go about this?
SELECT DISTINCT DEV_user_registration.reg_fname + ' ' + DEV_user_registration.reg_lname AS DEV_user_registration.fullname FROM DEV_user_registration WHERE DEV_user_registration.reg_agent = 'Yes' AND DEV_user_registration_fullname = '$_GET[agent_name]' ";
Any help would be great....thank you