By Title By Subject On Trial |
|
$group=$_GET["group"];
if($group==null)
$group="ad";
$groups= array("ad","el","mz","chi");
for($i=0;$i<4;$i++){
if($groups[$i]==$group){ ?>
[G] = Guide, [T] = Title List, [L] = Login Information
|
}
}
?>
include("globals.php");
$link = mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password)
or die ("Can not connect to MySQL");
if (mysql_select_db ($MySQLDatabasename)) {
if($group=="ad")
$string="select * from dblist where eng=1 and dbname <= 'e' order by dbname";
if($group=="el")
$string="select * from dblist where eng=1 and dbname >='e' and dbname <='m' order by dbname";
if($group=="mz")
$string="select * from dblist where eng=1 and dbname >='m' order by dbname";
if($group=="chi")
$string="select * from dblist where chi=1 order by dbname";
mysql_query('SET NAMES utf8');
if ($result=mysql_query($string)) {
while($row=mysql_fetch_array($result)){
echo "";
echo "Title: ".$row["dbname"]." ";
if($row["dbcom"]!="")
echo " by ";
echo $row["dbcom"]." ";
if($row["glink"]!="")
echo" [G] ";
if($row["tlink"]!="")
echo" [T] ";
if($row["llink"]!="")
echo" [L] ";
if($row["comment"]!="")
echo " ";
echo"
| ";
}
}
else "qerror";
}else
echo "error";
mysql_close($link);
?>
|
|