Eco-$mart Invoices
List Authorized Invoices

Authorized Invoices

Help

Error retrieving data from data base.
" . "Error: ". mysql_error(). ""); } $num_rows = mysql_num_rows($listem); if($num_rows < 1){ echo("

There are No Invoices

"); }else{ 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]; $status = $row['status']; if($status == 'new'){ $stat = " "; }elseif($status == 'Authorized'){ $stat = " "; }elseif($status == 'Billed'){ $stat = " "; }elseif($status == 'Paid'){ $stat = " "; }else{ $stat = " "; } $prgrss = $row['prgrss']; $prgnum = $prgrss*3; $prgpress = "" . "

" . "

" . "

"; mysql_select_db('ecosmar_contacts', $dbcnx); $listcon = @mysql_query("SELECT Name,Company,City,State,ZipCode FROM con_main WHERE ID='$CID'"); if (!$listcon) { echo "Contact Error: ". mysql_error(); }else{ $con = mysql_fetch_array($listcon); $Name = $con[0]; $Company = $con[1]; $City = $con[3]; $State = $con[4]; $ZipCode = $con[5]; } echo("" . "" . "" . "" . "

$statInvoice Number: $invnum

Invoice Date: $datus

Rep: $rep

" . "" . "

" . "[ Monitor ]" . "[ Finalize ]" . " [ Edit Shipping ]" . " [ Record Payments ]" . "	$Name   $Company" . " $City, $State $ZipCode" . "	Due: $duedate" . " Balance: $balance
	Progress: $prgpress" . "

"); } } ?>  

New Invoices   All Invoices   Return to Your Page

©2007 - Data Base Interface - Custom Built at: