|
Sign Out
Student Online Audio/Video Access
Available Titles
Title  |
Description  |
if($by != "")
$query = "SELECT MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink from MM_access, MM_titles where MM_access.UserName = '$mmuser' and MM_titles.Title = MM_access.Title GROUP BY MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink ORDER BY MM_titles.Description $by ";
elseif ($by2 != "")
$query = "SELECT MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink from MM_access, MM_titles where MM_access.UserName = '$mmuser' and MM_titles.Title = MM_access.Title GROUP BY MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink ORDER BY MM_titles.Title $by2";
else
$query = "SELECT MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink from MM_access, MM_titles where MM_access.UserName = '$mmuser' and MM_titles.Title = MM_access.Title GROUP BY MM_titles.Language, MM_titles.Title, MM_titles.Description, MM_titles.DirectLink ORDER BY MM_titles.Title ASC";
//echo $query;
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
END;
if ($row1[3] != '') {
print <<$row1[1]
END;
} else {
print <<$row1[1]
END;
}
print <<$row1[2]
END;
}
?>
|
|
|