include "./inc_top.html"; @extract($_GET); ?> $dbcon = OCILogon("khmc", "Kyunghee!1971", "khmcwdb" ,"AL32UTF8"); $wsql.= "WHERE 1=1 "; switch ( $table ) { case "mdlecture" : $title_msg = "의학상식"; $qwhere = " WHERE title NOT LIKE '%갑상선 교실%' AND title NOT LIKE '%100가지%' AND title NOT LIKE '%140%' AND title NOT LIKE '%째횉%' AND title NOT LIKE '%짚쨘쨍%'"; break; case "dmlecture" : $title_msg = "치과상식"; break; case "omlecture" : $title_msg = "한방상식"; break; default : $table = "mdlecture"; $title_msg = "의학상식"; break; } if( $sort == "dept" ) { $worder = "name"; } else { $worder = "title"; } $stid = OCIParse($dbcon, " SELECT * FROM {$table} a $qwhere ORDER BY $worder ASC "); OCIExecute($stid); ?>