"); print(""); print(""); include("php-lib/left_hand_column.php"); print(""); $TableName="images_front_page"; $Query="SELECT * from $TableName order by rand() limit 1"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { // is there a small image AND a large image? ; // if not, $image and $caption are blank ; if (!$Row[image_filename] && !$Row[large_image_filename]) { $image=""; $row_caption=""; } // is there a small image but NO large image? ; // if yes, $image is good but $caption is blank ; if ($Row[image_filename] && !$Row[large_image_filename]) { $title="title=\"$Row[title_text]\" "; $image=""; $row_caption=""; } // is there a small image AND a large image? ; // if yes, $image is good and $caption is good ; if ($Row[image_filename] && $Row[large_image_filename]) { $title="title=\"$Row[title_text]\" "; $image=""; $row_caption="Click on the image to see a larger version."; } } $TableName="text_front_page"; $Query="SELECT * from $TableName order by rand() limit 1"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { $text="$Row[front_page_text]"; if ($Row[front_page_heading]) { $heading="

$Row[front_page_heading]

"; $row_heading="$heading"; } else { $row_heading=""; } } print(""); print(""); print("$row_heading"); print("$row_caption"); print(""); print(""); print(""); print("
$image$text

 
 

"); $i=0; $num=4; print(""); print(""); $TableName="images_random"; $Query="SELECT * from $TableName order by rand() limit 1"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { if ($Row[image_filename]) { print(""); print(""); } } $Query="SELECT * from $TableName order by rand() limit 4"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { $title="title=\"$Row[title_text]\" "; if ($i==0) print (""); if ( ($i>0) && ( $i%$num==0) ) print (""); print(""); $i++; } print("
 
"); print("
"); $i=0; $num=3; print(""); print(""); $TableName="images_sponsors"; $Query="SELECT * from $TableName order by rand() limit 1"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { if ($Row[image_filename]) { print(""); print(""); print(""); } } $Query="SELECT * from $TableName order by rand() limit 3"; $Result=mysql_db_query ($DBName, $Query, $Link); while ($Row=mysql_fetch_array ($Result)) { $title="title=\"$Row[title_text]\" "; if ($i==0) print (""); if ( ($i>0) && ( $i%$num==0) ) print (""); print(""); $i++; } print("
 
Our much-appreciated and valued sponsors.
 
"); print(""); include("php-lib/footer_public.php"); ?>