From: Chris S. <san...@us...> - 2005-09-09 11:15:07
|
Update of /cvsroot/stack/stack-1-0/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19275/scripts Modified Files: stackDatabase.php Log Message: Index: stackDatabase.php =================================================================== RCS file: /cvsroot/stack/stack-1-0/scripts/stackDatabase.php,v retrieving revision 1.48 retrieving revision 1.49 diff -C2 -d -r1.48 -r1.49 *** stackDatabase.php 7 Sep 2005 14:19:35 -0000 1.48 --- stackDatabase.php 9 Sep 2005 11:14:59 -0000 1.49 *************** *** 2016,2019 **** --- 2016,2042 ---- /** + * Checks a quiz is really in the subject. + * + * @param int $subjectID The subjectID number of the subject needed. + * @param int $quizid The quizid of the quiz + * @return void + */ + function stack_db_subject_quiz_contained($subjectID,$quizid) { + + $exists = FALSE; + + $query = "SELECT quizid FROM subject_quiz WHERE subjectID = '$subjectID' AND quizid = '$quizid'"; + + $result = stack_db_query($query); + if(0 != mysql_num_rows($result)) { + $exists = TRUE; + } + + return $exists; + + } + + + /** * Drop a quizid from a subject * |