Honor your hero

FLORIDA TODAY salutes the men and women deployed in Iraq, Afghanistan or serving in the military elsewhere, whether abroad or at home.
"; $username="htuser"; $password="HTHeroes39"; $database="hometown"; mysql_connect("db1.flatoday.net",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $q="SELECT * FROM HOMETOWNHEROS WHERE yesno = '1'"; $r=mysql_query($q); $numrows=mysql_num_rows($r); echo ""; if (empty($offme)){$offme = 0;} if (empty($order)){$order= 'id';$DESC = 'DESC';} mysql_connect("db1.flatoday.net",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM HOMETOWNHEROS WHERE yesno = '1' ORDER BY id DESC LIMIT $offme,10 "; $result=mysql_query($query); $num=mysql_num_rows($result); mysql_close(); $DESC = ''; $i=0; $count=0; while ($i < $num) { $id=mysql_result($result,$i,"id"); $FIRSTNAME=mysql_result($result,$i,"FIRSTNAME"); $LASTNAME=mysql_result($result,$i,"LASTNAME"); $DATE=mysql_result($result,$i,"DATE"); $COUNTYCONNECTION=mysql_result($result,$i,"COUNTYCONNECTION"); $BRANCH=mysql_result($result,$i,"BRANCH"); $RANK=mysql_result($result,$i,"RANK"); $COMMENTS=mysql_result($result,$i,"COMMENTS"); $UNIT=mysql_result($result,$i,"UNIT"); $HOMEBASE=mysql_result($result,$i,"HOMEBASE"); $HOWLONG=mysql_result($result,$i,"HOWLONG"); $WHERESERVING=mysql_result($result,$i,"WHERESERVING"); $CURRENTASSIGN=mysql_result($result,$i,"CURRENTASSIGN"); $SUBNAME=mysql_result($result,$i,"SUBNAME"); $SUBEMAIL=mysql_result($result,$i,"SUBEMAIL"); $SUBRELATION=mysql_result($result,$i,"SUBRELATION"); $FILENAME=mysql_result($result,$i,"FILENAME"); $yesno=mysql_result($result,$i,"yesno"); echo " "; $i++; $count++; if ($count =='1'){echo "";$count=0;} } ?>
"; if (($offme == '0') || ($offme == '')){ echo "

There are $numrows Hometown Heroes!"; } echo "". mysql_error(); if ($numrows == '0'){}else{ $pages = $numrows / 10; $start = 0; function round_up($value){ list($val,$dummy) = explode(".",$value); return $dummy?$val+1:$val; } $pages = ceil($pages); $p = 1; if ($pages > 0 ){ echo "
Pages: ";} while ($pages > 0 ) { echo "$p "; $start = $start + 10; $p++; $pages--; } } echo"

"; //if($FILENAME != ""){echo"";} echo"
"; if($FILENAME != ""){echo"";} echo"

$FIRSTNAME $LASTNAME

Date Submitted: $DATE
Brevard County Connection: $COUNTYCONNECTION
Branch: $BRANCH
Rank: $RANK
Comments: $COMMENTS
Unit: $UNIT
Home Base: $HOMEBASE
Serving How Long: $HOWLONG
Where Serving: $WHERESERVING
Current Assignment: $CURRENTASSIGN"; mysql_connect("db1.flatoday.net",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $sql="SELECT * FROM HOMETOWNHEROS_COMMENTS where idnumber = $id and yesno = 'yes'"; $commentresult=mysql_query($sql); $commentnum=mysql_num_rows($commentresult); echo"
Comments: ($commentnum) Read comments
"; // | Add comment echo"