by name";
$sub=mysql_query("select id, subject from subject where id=$id");
$sub=mysql_fetch_array($sub);
$where=$sub["subject"];
$sql=mysql_query("select s.id,subject,title,url,description,remote from subject s, data d,subject_lookup where s.id = $id and s.id = sub_id and d.id = db_id order by title");
break;
case "vendor":
$heading = "Vendor";
$menu = "List by subject or by name";
$ven=mysql_query("select id, vendor from vendor where id=$id");
$ven=mysql_fetch_array($ven);
$where=$ven["vendor"];
$sql=mysql_query("select v.id,vendor,s.id,subject,title,url,description,remote from vendor v, subject s, data where v.id = $id and v.id=vid and s.id=sid order by title");
break;
case "alpha":
$heading = "Name";
$where = $search;
$menu = "List by subject";
if ($search == "A-C") {$sql=mysql_query("select title,url,description,remote from data where title between 'a%' and 'd%' order by title");}
if ($search == "D-F") {$sql=mysql_query("select title,url,description from data where title between 'd%' and 'g%' order by title");}
if ($search == "G-I") {$sql=mysql_query("select title,url,description,remote from data where title between 'g%' and 'j%' order by title");}
if ($search == "J-N") {$sql=mysql_query("select title,url,description,remote from data where title between 'j%' and 'o%' order by title");}
if ($search == "O-S") {$sql=mysql_query("select title,url,description,remote from data where title between 'o%' and 't%' order by title");}
if ($search == "T-Z") {$sql=mysql_query("select title,url,description,remote from data where title between 't%' and 'z%' order by title");}
break;
}
?>
Library Databases - By <? echo $heading; ?>
