[Etest-cvs] etest/instructor inst_setup_test.php,1.7,1.8

[<cpj...@us...>]

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

Modified Files:
	inst_setup_test.php 
Log Message:
updated querys to use DB_prefix -- craig

Index: inst_setup_test.php
===================================================================
RCS file: /cvsroot/etest/etest/instructor/inst_setup_test.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** inst_setup_test.php	8 Mar 2004 15:32:45 -0000	1.7
--- inst_setup_test.php	8 Mar 2004 15:37:54 -0000	1.8
***************
*** 105,112 ****
  require('../includes/db_connect.php'); //returns file link identifier $db and selects proper database
  
! $sql = "SELECT Course.Course_Code,Section_Code,Course_Name
! 		FROM  ".$DB_prefix."_Course
! 		INNER JOIN  ".$DB_prefix."_Section ON Course.Course_Code=Section.Course_Code
! 		WHERE Inst_Code='$_SESSION[username]' ORDER BY Course.Course_Code";
  		
  $result = @mysql_query($sql) or die("Couldn't execute query.");
--- 105,112 ----
  require('../includes/db_connect.php'); //returns file link identifier $db and selects proper database
  
! $sql = "SELECT ".$DB_prefix."_Course.Course_Code,".$DB_prefix."_Section_Code,Course_Name
! 		FROM ".$DB_prefix."_Course
! 		INNER JOIN ".$DB_prefix."_Section ON ".$DB_prefix."_Course.Course_Code=".$DB_prefix."_Section.Course_Code
! 		WHERE Inst_Code='$_SESSION[username]' ORDER BY ".$DB_prefix."_Course.Course_Code";
  		
  $result = @mysql_query($sql) or die("Couldn't execute query.");