Mike Coucoules Benefit 2006Our ***NEW*** picture library 2006The Swiss 2000Sunbanks Resort 2001 Blues OdysseyMore PicsOur photo site ** NEW ** note: long load but maybe worth it
The Malcolm Clark Band
"; break; case BC: $line1="Blues Companion
"; break; case 'OM': $line1="Open Mics and Jams
"; break; case 'FR': $line1="Malcolm and Others
"; break; case 'lf2006': $line1 = "LouieFest 2006
"; break; case 'BRUNO': $line1 = "Bruno Nedegard's Goin' Away Party
"; break; case 'bostwick2001': $line1 = 'Bostwick2001
'; break; case 'bostwick2005': $line1 = 'Bostwick2005
'; break; case 'CANJAM2006': $line1 = "
Can Jam 2006
"; break; case 'ocal': $line1 = "
O'callihans 2006
"; break; case 'schmngy2006': $line1 = "
SchmngyFest 2006
"; break; case 'seaf2006': $line1 = "
Seafarers 2006
"; break; case 'shire': $line1 = "
The Shire 2005
"; break; default: echo "If you use no input, you get no output.
"; } // end of if statement $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "$line1"; echo "Maintenance Section Info
"; echo "Database Output
"; echo "Number of records selected: $num
" ; echo " $owner"; echo "
"; echo "
| ";
echo " "; echo "$desc $year Location: $location Owner: $owner Id: $id Filename: $pic_file"; echo " | ";
$i++;
$pic_file=mysql_result($result,$i,"pic_file");
$location=mysql_result($result,$i,"location");
$desc=mysql_result($result,$i,"desc");
$year=mysql_result($result,$i,"year");
$owner=mysql_result($result,$i,"owner");
$id=mysql_result($result,$i,"id");
echo "";
echo " "; echo "$desc $year Location: $location Owner: $owner Id: $id Filename: $pic_file"; echo " |