require("sidebar.inc"); ?>
|
require("title.inc"); ?>
Music Selections
In order to assist us in the music selection for our reunion event, would you please use this page to list the songs that you would like to hear from that era. If you have a decent mp3 copy of the song please email music@dorvalhigh.com for instructions on how to transfer it to the site.
|
echo '
if ( $s == 'Submit' ) {
if ( $gy <= '' || $g <= '' || $t <= '' )
echo "Invalid entry: year, group and song title are required | ";
else {
$query = 'insert into music (grad_year,group_name,title) values ("' . $gy . '","' . $g . '","' . $t . '")';
mysql_query( $query ) or die( $query );
}
}
if ( $s == 'Del' ) {
$query = "delete from music where id=" . $Delete;
mysql_query( $query ) or die( $query );
}
$query = "select * from music order by grad_year,group_name,title";
$result = mysql_query( $query ) or die( $query );
while( $line = mysql_fetch_array( $result ) ) {
echo "";
if ( $del_flag == "y" ) {
echo '';
}
echo " | " . $line["grad_year"] . " | ";
echo "";
echo $line["group_name"] . ' | ';
echo "";
echo $line["title"];
echo " | ";
}
$query = "select count(*) from music";
$result = mysql_query( $query ) or die( $query );
$line = mysql_fetch_array( $result );
echo " | | $line[0] listed | ";
?>
|
|
|