Photo Album Index-Text // photoindextest.php - by Joseph Sottnik // code that will be executed if the form has been submitted: include("sort.inc"); $query="SELECT Title,PhotoID,FileSize,PhotoDate FROM Photograph ORDER BY "; switch($sort_order) { case 1: $sort_opt="PhotoDate"; break; case 2: $sort_opt="Title"; break; case 3: $sort_opt="FileSize"; break; default: $sort_opt="PhotoID"; } $query=$query.$sort_opt; if($asc_desc=="DESC") $query.=" DESC"; $result=mysql_query($query); print "

Click on a Photo ID to see the full photo."; ?> "; $photo=mysql_fetch_row($result); print ""; } print "
TitleIDSizePhoto Date
$photo[0]"; print "$photo[1]"; print "$photo[2]"; print "$photo[3]"; print "
"; print "

This page last revised on August 12, 2000

"; include("copyright.txt"); ?>