$myconnection=mysql_connect("localhost","spir7343_SCCREAD","War27Q=OhpV~") or die ("Couldn't connect to the server."); $db=mysql_select_db("spir7343_spiritscallchoir_data",$myconnection) or die("Couldn't select database"); $sql="SELECT * FROM scc_ngg_gallery;"; $sql_result=mysql_query($sql,$myconnection) or die ("Couldn't execute query."); $links= "
- \n”;
- $row[title]
while($row=mysql_fetch_array($sql_result)) {
if($_GET[gid]==$row[gid]||$_GET[gid]==””) {
$_GET[gid]=$row[gid];
$title=$row[title];
$description=$row[galdesc];
$user_id=$row[author];
}
$links.= “
\n”;
}
$links.= “
\n”;
$user_info=get_userdata($user_id);
$author=$user_info->first_name.” “.$user_info->last_name;
if($author==””) $author=$user_info->display_name;
mysql_free_result($sql_result);
mysql_close($myconnection);
?>
echo $title; ?>echo $description; ?> |
userphoto_thumbnail($user_id, "", $before="Created by $author”,array(hspace => ’10px’,valign => ‘bottom’, align => right)); ?> |
|
Choir Albumsecho $links; ?> |