So my query is being odd,
When i run the submit and code of one query the results of this query also prints too, I’m not sure why.
so for example, if I run:
[php]$average = $_POST[‘average’];
$query5 = "SELECT c.con_fname, r.Reviewer_Contact_con_id, question_id, AVG( DISTINCT question_score)
FROM Contact c, Individual_Review r
WHERE r.Reviewer_Contact_con_id = c.con_id
AND con_fname = ";
$query5 = $query5 . “’” . $average . “’ GROUP BY r.Proposal_proposal_id;”;[/php]
it works, but it also prints the results of this query:
[php]$check = $_POST[‘check’];
$query7 = “Select c.con_fname, c.con_lname, s.Contact_con_id,
IF(s.Contact_con_id IS NULL, ‘NO’, ‘YES’)
From Contact c Left Join (Select Contact_con_id FROM Speakers
WHERE speaker_year = '”. $check . “’) As s
ON c.con_id = s.Contact_con_id”;
$query7 = $query7 . " ORDER BY c.con_fname;";[/php]
If anyone could help point me the right way, that’d be great!
Thanks ;D