$song_id=mysql_real_escape_string($_GET["song_id"]);
##$query="SELECT Title, source, song_id, CCL_date, song_notes, date_registered, DATE_FORMAT(date_last_performed, '%D %b %Y'), ISBN, authors, song_directions, twynham FROM songs where song_id=$song_id";
$query="SELECT Title, source, song_id, CCL_date, song_notes, date_registered, date_last_performed, ISBN, authors, song_directions, twynham FROM songs where song_id=$song_id";
$result=mysql_query($query);
$num=mysql_numrows($result);
$Title=mysql_result($result,$i,"Title");
$source=mysql_result($result,$i,"source");
$song_id=mysql_result($result,$i,"song_id");
$CCL_date=date("jS M Y", strtotime(mysql_result($result,$i,"CCL_date")));
$song_notes=mysql_result($result,$i,"song_notes");
$date_registered=date("jS M Y", strtotime(mysql_result($result,$i,"date_registered")));
##$date_last_performed=mysql_result($result,$i, "DATE_FORMAT(date_last_performed, '%D %b %Y')");
$date_last_performed=date("jS M Y", strtotime(mysql_result($result,$i, "date_last_performed")));
$ISBN=mysql_result($result,$i,"ISBN");
$authors=mysql_result($result,$i,"authors");
$song_directions=str_replace(chr(13), " ", mysql_result($result,$i,"song_directions"));
$twynham=mysql_result($result,$i,"twynham");
echo "
$Title
";
echo "
Title
"; echo "
$Title
";
echo "
Source
"; echo "
$source
";
echo "
Song ID
"; echo "
$song_id
";
echo "
CCL date
"; echo "
$CCL_date
";
echo "
Song notes
"; echo "
$song_notes
";
echo "
Date registered
"; echo "
$date_registered
";
if ($date_last_performed == "1st Jan 1970") {
echo "
Date last performed
"; echo "
(never)
";
} else {
echo "
Date last performed
"; echo "
$date_last_performed
";
};
echo "
ISBN
"; echo "
$ISBN
";
echo "
Authors
"; echo "
$authors
";
echo "
Song directions
"; echo "
$song_directions
";
##echo "
Twynham
"; echo "
$twynham
";
$query="SELECT DATE_FORMAT(date, '%D %b %Y'), venue, method, chooser FROM performance WHERE ((song_id=$song_id)) ORDER BY date DESC";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
if ($num >0) {
echo "";
echo "