$DBhost = "localhost"; $DBuser = "priceweb"; $DBpass = "aquzvABn"; $DBName = "lange79_priceweb"; $table = "bc_lg_downloads"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); @mysql_select_db("$DBName") or die("Unable to select database $DBName"); $query="SELECT * FROM $table WHERE carrier ='Blue Cross Large Group' ORDER by 'file_id' DESC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); if ($num>1) { $to=1; }else{ $to=$num; } $i=0; while ($i < $to) { $_GET['file_ul']=mysql_result($result,$i,"file_ul"); ?> $i++; } ?>
Blue Cross Large Group Downloads - Updated
Form #
Effective
$DBhost = "localhost"; $DBuser = "priceweb"; $DBpass = "aquzvABn"; $DBName = "lange79_priceweb"; $table = "bc_lg_downloads"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); @mysql_select_db("$DBName") or die("Unable to select database $DBName"); $query="SELECT * FROM bc_lg_downloads WHERE carrier ='Blue Cross Large Group' ORDER by file_title ASC"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); if ($num>65000) { $to=65000; }else{ $to=$num; } $i=0; while ($i < $to) { $_GET['datEnd']=mysql_result($result,$i,"datEnd"); $_GET['carrier']=mysql_result($result,$i,"carrier"); $_GET['form']=mysql_result($result,$i,"form"); $_GET['file_title']=mysql_result($result,$i,"file_title"); $_GET['file_link']=mysql_result($result,$i,"file_link"); ?>
echo $_GET['file_title']; ?>
echo $_GET['form']; ?>
echo date('m/y',strtotime($_GET['datEnd'])); ?>
$i++; } ?>