Author Topic: retrieving value from a query  (Read 127 times)

cogga28

  • Regular Member
  • **
  • Posts: 75
  • Karma: +0/-0
    • View Profile
retrieving value from a query
« on: February 03, 2012, 11:55:45 AM »
PHP Code: [Select]

$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"
);

how can i store the value created from this query as a vairable??