Song Details

", mysql_result($result,$i,"song_directions")); $twynham=mysql_result($result,$i,"twynham"); echo "

$Title

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($date_last_performed == "1st Jan 1970") { echo ""; echo ""; } else { echo ""; echo ""; }; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ##echo ""; echo ""; $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 "
Title$Title
Source$source
Song ID$song_id
CCL date$CCL_date
Song notes$song_notes
Date registered$date_registered
Date last performed(never)
Date last performed$date_last_performed
ISBN$ISBN
Authors$authors
Song directions$song_directions
Twynham$twynham
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } else { echo "(never sung)"; } while ($i < $num) { $date=mysql_result($result,$i,"DATE_FORMAT(date, '%D %b %Y')"); $venue=mysql_result($result,$i,"venue"); $chooser=mysql_result($result,$i,"chooser"); $method=mysql_result($result,$i,"method"); $performance_date= date("Y-m-d", strtotime($date)); $i++; echo ""; echo ""; echo ""; if ( $chooser <> "" ) { echo ""; } else { echo ""; } echo ""; echo ""; } mysql_close(); ?>

Back
Date sungVenueChosen byMethod
$date$venue$chooser$chooser$method