Error retrieving data from data base.
" . "Error: ". mysql_error(). " |
");
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("
| There are No New Invoices |
");
}else{
mysql_select_db('ecosmar_contacts', $dbcnx);
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$repusrn = $row['usrn'];
$invnum = $row['invnum'];
$CID = $row['CID'];
$rep = $row['rep'];
$due = $row['due'];
$chunk_due = chunk_split($due, 2, ':');
$chunk_arrg = explode(":", $chunk_due);
$duedate = $chunk_arrg[2].'-'.$chunk_arrg[3].'-'.$chunk_arrg[0].$chunk_arrg[1];
$balance = $row['balance'];
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1];
$prgrss = $row['prgrss'];
$prgnum = $prgrss*3;
$prgpress = "
" .
" |
" .
"" .
" |
";
$listcon = @mysql_query("SELECT first_Name,Name,Company,City,State,ZipCode FROM con_main WHERE ID='$CID'");
if (!$listcon) {
echo "Con Error: ". mysql_error();
}else{
$con = mysql_fetch_array($listcon);
$first_Name = $con[0];
$Name = $con[1];
$Company = $con[2];
$City = $con[3];
$State = $con[4];
$ZipCode = $con[5];
}
echo("
" .
"| Invoice# $invnum | " .
"Representative: $rep | " .
"Invoice Date: $datus |
" .
"| " .
"[ Manage ]" .
" | $first_Name $Name $Company" .
"
$City, $State $ZipCode" .
" | Due: $duedate" .
"
Balance: $balance |
");
}
}
?>
| |
" .
"
" .
"
" .
"