[php]// query to get all records from class what the user belongs to by user id
$qry = mysql_query(“SELECT Class., Test., Result.*
FROM
Class INNER JOIN Test
ON Class.className = Test.className
INNER JOIN Result
ON Test.testID = Result.testID
WHERE Test.deadline < ‘date(d-m-Y)’ AND Class.userID =’$_SESSION[SESS_MEMBER_ID]’;”);
while($row = mysql_fetch_array($qry)){
$option .= ‘
’
$count ++;
}[/php]
i am trying to echo the variable option where the found record does not exist in results but does exist in test