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