[Etest-cvs] etest/student student_select_test.php,1.9,1.10

[<cpj...@pr...>]

Update of /cvsroot/etest/etest/student
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26456/etest/student

Modified Files:
	student_select_test.php 
Log Message:
fixed query with DB_prefix

Index: student_select_test.php
===================================================================
RCS file: /cvsroot/etest/etest/student/student_select_test.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** student_select_test.php	27 Jan 2004 16:40:48 -0000	1.9
--- student_select_test.php	1 Feb 2004 03:05:10 -0000	1.10
***************
*** 27,31 ****
      $_SESSION['test_completed'] = false;   // student hasnt taken test at this point
  
!     $sql_query    = "SELECT * FROM ".$DB_prefix."_enroll INNER JOIN course ON ".$DB_prefix."_enroll.Course_Code = ".$DB_prefix."_course.Course_Code WHERE ".$DB_prefix."_enroll.Student_Code='".$_SESSION['username']."'";
  	$query_result = mysql_query($sql_query, $db) or die('Cannot run enroll classes query '.mysql_error());
  	$query_num = mysql_num_rows($query_result);
--- 27,31 ----
      $_SESSION['test_completed'] = false;   // student hasnt taken test at this point
  
!     $sql_query    = "SELECT * FROM ".$DB_prefix."_enroll INNER JOIN ".$DB_prefix."_course ON ".$DB_prefix."_enroll.Course_Code = ".$DB_prefix."_course.Course_Code WHERE ".$DB_prefix."_enroll.Student_Code='".$_SESSION['username']."'";
  	$query_result = mysql_query($sql_query, $db) or die('Cannot run enroll classes query '.mysql_error());
  	$query_num = mysql_num_rows($query_result);