Paradise Valley Community College; 18401 North 32nd Street; Phoenix, Arizona, 85032

Athletics News
"; if ($row["credits"]) { echo "

 
 
Sort this page with these buttons
 
 

Athletic News Articles from " . $lastyear . "

"; echo "
"; $result=mysql_query("select *, date_format(rdate, '%M %e, %Y') as rdate from sportnews where year = $thisyear order by $order") or die (mysql_error()); while ($row=mysql_fetch_array($result)) { if ($row["sport"]=="News") {$sportname="News";} if ($row["sport"]=="Mens_Golf") {$sportname="Men’s Golf";} if ($row["sport"]=="Cross_country") {$sportname="Cross Country";} if ($row["sport"]=="Track_&_Field") {$sportname="Track & Field";} if ($row["sport"]=="Womens_Soccer") {$sportname ="Women’s Soccer";} if ($row["sport"]=="Mens_Soccer") {$sportname="Men’s Soccer";} if ($row["sport"]=="Softball") {$sportname="Softball";} if ($row["sport"]=="Mens_Tennis") {$sportname="Men’s Tennis";} if ($row["sport"]=="Womens_Tennis") {$sportname="Women’s Tennis";} if ($row["sport"]=="Womens_Golf") {$sportname="Women’s Golf";} $content = nl2br($row["body"]); $photo_table_start ="
\"space\" "; $photo_table_end = "
"; if ($row["photo"]) { $upfile = "../" . $row["photo"]; //create variable for width height function below echo $photo_table_start; echo "Click on photo to see original
";//adds a link to see the full photo in another window // BEGIN variable width height function for photo // Max width and height for images uploaded by users. This will keep dimensions of original image $max_width = 160; $max_height = 500; $size = GetImageSize($upfile); // Read the size $width = $size[0]; $height = $size[1]; // Proportionally resize the image to the // max sizes specified above $x_ratio = $max_width / $width; $y_ratio = $max_height / $height; if( ($width <= $max_width) && ($height <= $max_height) ) { $tn_width = $width; $tn_height = $height; } elseif (($x_ratio * $height) < $max_height) { $tn_height = ceil($x_ratio * $height); $tn_width = $max_width; } else { $tn_width = ceil($y_ratio * $width); $tn_height = $max_height; } echo ""; // *** end of variable width height function // OLD echo "
".$row["credits"]; } if ($row["caption"]) { echo "
".$row["caption"]; } echo $photo_table_end; } echo ""; echo $sportname; echo "

"; echo ""; if ($row["rdate"]) { echo $row["rdate"]; } else { echo $row["date1"]; } echo "
"; echo $row["title"]; echo "

"; if ($row["body"]) { $content = $row["body"]; make_clickable($content); } echo "
"; } echo "
"; include("../cms_foot_inc.php"); ?>