<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_GET['usrn']; $ID = $_GET['ID']; $today = date("F j, Y"); $dtnum = date(Ymd); $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $ok = @mysql_query("SELECT ID,usrn,email FROM psw WHERE usrn='$usrn'"); if (!$ok) { echo 'Could not retrieve Representative ID: ' . mysql_error(); } $rowa = mysql_fetch_array($ok); $RID = $rowa[0]; $rep = $rowa[1]; $rep_email = $rowa[2]; mysql_select_db('ecosmar_friendly', $dbcnx); $list = @mysql_query("SELECT CID,Project_ID,Project_Type,Project_Description,Product,item_no,est_qty,quote_qty,issue,quote_price,dtnum FROM quotes WHERE ID='$ID'"); if (!$list) { echo("

Error retrieving quote from data base.
" . "Error: ". mysql_error(). "

"); }else{ $row = mysql_fetch_array($list); $CID = $row['CID']; $Project_ID = $row['Project_ID']; $Project_Type = $row['Project_Type']; $Project_Description = $row['Project_Description']; $Product = $row['Product']; $item_no = $row['item_no']; $est_qty = $row['est_qty']; $quote_qty = $row['quote_qty']; $issue = $row['issue']; $quote_price = $row['quote_price']; $dtnum = $row['dtnum']; mysql_select_db('ecosmar_contacts', $dbcnx); $listem = @mysql_query("SELECT ID,first_Name,Name,Company,Phone,Address,FAX,City,email,State,ZipCode FROM con_main WHERE ID='$CID'"); if (!$listem) { echo('

Error retrieving data from data base.
' . 'Error: '. mysql_error(). '

'); } $rowb = mysql_fetch_array($listem); $CID = $rowb['ID']; $first_Name = $rowb['first_Name']; $Name = $rowb['Name']; $Company = $rowb['Company']; $Phone = $rowb['Phone']; $Address = $rowb['Address']; $FAX = $rowb['FAX']; $City = $rowb['City']; $email = $rowb['email']; $State = $rowb['State']; $ZipCode = $rowb['ZipCode']; $customer = "$Company
$first_Name $Name
$Address
$City, $State $ZipCode
$email
$Phone
$FAX"; mysql_select_db('ecosmar_inv', $dbcnx); $id_max = mysql_query("SELECT MAX(id) FROM ecoinvoice"); $id_macs = mysql_result($id_max); $TID = $id_macs + 1; $invnum = $dtnum.$CID.$RID.$TID; mysql_select_db('ecosmar_contacts', $dbcnx); $ok2 = @mysql_query("SELECT ID,status FROM special WHERE email='$email'"); if (!$ok2) { echo 'Trouble finding Special Status: ' . mysql_error(); }else{ $rowb = mysql_fetch_array($ok2); $SID = $rowb['ID']; $special = $rowb['status']; } if($special != ""){ $spec_notify = "This Contact has been authorized for Eco-\$mart Special Pricing.  " . "Status:  $special  OK"; }else{ $special = 'None'; } } ?>

Eco-$mart, Inc.
4411 Bee Ridge Road #344
Sarasota, FL 34233
PH. 888-329-2705   FX: 941-377-9460
www.ecosmartinc.com

Quote
Date Invoice #
   
Representative
 
Bill To: Ship To:      Same as Bill To:
Company: 
Name: 
Address: 
City: 
State: 
Phone: 



  ZipCode: 
P.O. Number Terms Est. Delivery Project
Item Code Description Quantity Price Unit Amount