latest news
biography
audio & video
photographs
gigs
comments
mailing list
contact
links
gigs
$username="joseph_tj105"; $password="pass123"; $database="joseph_dannyhook"; mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM gigs ORDER BY datemonth DESC , dateday DESC, dateyear DESC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?>
$i=0; while ($i < $num) { $dateday=mysql_result($result,$i,"dateday"); $datemonth=mysql_result($result,$i,"datemonth"); $dateyear=mysql_result($result,$i,"dateyear"); $timehr=mysql_result($result,$i,"timehr"); $timemin=mysql_result($result,$i,"timemin"); $venue=mysql_result($result,$i,"venue"); $street=mysql_result($result,$i,"street"); $city=mysql_result($result,$i,"city"); $postcode=mysql_result($result,$i,"postcode"); ?>
echo $dateday.".".$datemonth.".".$dateyear; ?>
echo "$venue";?>
echo $street.", ".$city.", ".$postcode; ?>
Time: echo $timehr.":".$timemin; ?>
++$i; } echo "
"; ?>