[php]
$qry = mysql_query(“select DISTINCT User.userID
from Result inner join
(Test inner join
(Class inner join User
on Class.userID=User.userID)
on Test.className=Class.className)
on Result.testID=Test.testID
where Test.className=’$testClass’
AND not exists(select Class.userID
from Result
Where Class.userID=result.markerID
AND Result.testID=’$testID’)
ORDER BY Rand() limit 1”);
[/php]
how can i store the value created from this query as a vairable??
