Code: Select all
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query = "SELECT
salutation,name,surname,organisation,email,address,address1,
telephonefax,mobile,mscints,mscactive,gradjobs,ugproj,pdev,bcsmem,bcspds,teach,acconsult,person_id FROM feedbackcontacts
FROM feedbackcontacts
WHERE name LIKE '$formVars[name]%'";
$result = mysql_query($query);Code: Select all
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query = "SELECT
o.org_id,o.web_url,
p.person_id,p.org_id,p.salutation,p.firstname,p.surname,
p.organisation,p.role,p.address1,p.address2,p.city,
p.postcode,p.telephone,p.mobile,p.fax,p.dateoflastcontact,
p.datecontactagain,p.email,p.consultation_panel_member,
p.primary_contact,p.primarycontactemail,
p.advertising_grad_jobs,p.offer_mscproject,p.offer_ugproject,
p.professional_devactivities,p.bcs_membership,p.bcs_pds,
p.teaching_courses,p.academic_consultancy,
DATE_FORMAT(dateoflastcontact, '%M/%Y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%M/%Y')
AS datecontactagain
FROM people p LEFT JOIN organisations o
ON o.org_id = p.org_id
WHERE firstname LIKE '$formVars[firstname]%'";
$result = mysql_query($query);Any help would be much appreciated.