What do you think of my search quesry - im getting a blank screen can you see what im missing??
Code: Select all
// the query used to search the DB
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
PRINT $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.notes,p.email,p.datecontactagain,p.email,p.consultation_panel_member,p.primary_contact,primarycontactemail,
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 consultation_panel_member = '$formVars[consultation_panel_member]yes'";
$result = mysql_query($query);