$myconnection=mysql_connect("localhost","spir7343_library","8kpTaCQX%[~[") or die ("Couldn't connect to the server."); $db=mysql_select_db("spir7343_spiritscallchoir_library",$myconnection) or die("Couldn't select database"); $sql="SELECT * FROM choir_videos ORDER BY concert_date DESC;"; $sql_result=mysql_query($sql,$myconnection) or die ("Couldn't execute query."); $links= "
- \n”;
- $row[title]
while($row=mysql_fetch_array($sql_result)) {
if($first_link==””) $first_link=$row[link];
if($concert_date!==$row[concert_date]) {
$links.=”
“.date(“F d, Y”,strtotime($row[concert_date])).”
“;
}
$links.= “
\n”;
$concert_date=$row[concert_date];
if($_GET[url]==$row[link]||$_GET[url]==””) {
$_GET[url]=$row[link];
$title=$row[title];
$print_date=$concert_date;
$description=$row[description];
$user=$row[user];
}
}
$links.= “
\n”;
mysql_free_result($sql_result);
mysql_close($myconnection);
?>
; ?>“] echo " $title“; ?> “; ?> |
echo $links; ?> |