Location: PHPKode > projects > Decider > decider/Full_Answer_View/gethint.php
<?php

//get the q parameter from URL
$q=$_GET["quiz"];//lookup all hints from array if length of q>0

$k_p=$_GET["keyperson"];

require("../common/database.php");

//aquiring data for fake key person id
$my_query="select * from client_key_person where Id='".$k_p."'";

$my_result=mysql_query($my_query,$link);

$raw=mysql_fetch_array($my_result);

$k_p=$raw['Dkp_Id'];

//aquiring data for real key person id
$q_string="select * from quiz,client_feedback where turn='".$q."' and Keyperson_Id='".$k_p."' and Quiz_id=Id";

//$abc="SELECT * FROM initial_answers,initial_quiz WHERE Client_Name ='".$client."' AND Initial_Quiz_Id=Id "

$result=mysql_query($q_string,$link);

	$i=0;
	while($sqa = mysql_fetch_array($result)) {
	$i++;
		//Return each page title seperated by a newline.
		echo "<b>Q.".' '.$i."</b> ".$sqa['Question']."<br> <br> <b>Answer:</b>".' '.$sqa['Answer']."<br> <br>";
		
	}

mysql_close($link);

?>


Return current item: Decider