Cannot Continue without Quote Number.
"); exit(); } $CID=$_POST['CID']; if($CID==""){ $CID=$_GET['CID']; } $usrn=$_POST['usrn']; if($usrn==""){ $usrn=$_GET['usrn']; } if($usrn==""){ echo("Cannot Continue without Representative.
"); exit(); } $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); $usr=$_POST['usr']; if($usr==""){ $usr=$_GET['usr']; } mysql_select_db('ecosmar_inv', $dbcnx); $qetquote=mysql_query("SELECT CID,PO,Terms,started,due,printed,Project FROM quotes WHERE ID='$QID'"); if(!$qetquote){ echo("Could not get Quote information.
"); //echo mysql_error(); }else{ $rowq=mysql_fetch_array($qetquote); $CID=$rowq['CID']; $PO=$rowq['PO']; $Terms=$rowq['Terms']; $started=$rowq['started']; $due=$rowq['due']; $printed=$rowq['printed']; $Project=$rowq['Project']; if($CID!= ""){ mysql_select_db('ecosmar_contacts', $dbcnx); $getcon=mysql_query("SELECT first_Name,Name,Company,price_level FROM con_main WHERE ID='$CID'"); if(!$getcon){ echo("Could not get Contact Information.
"); //echo mysql_error(); }else{ $rowc=mysql_fetch_array($getcon); $first_Name=$rowc['first_Name']; $Name=$rowc['Name']; $Company=$rowc['Company']; $price_level=$rowc['price_level']; if($Company!=""){ $to=$Company; }//company is not blank else{ $to=$first_Name." ".$Name; } }//gotcon }//CID is not blank }//gotquote ?>|
Eco-$mart Quote NotesQuote -- Printed Representative: | ||
| QUOTE: | TO: | LEVEL: |
|
Could not connect to the Data Base.");
//echo mysql_error();
}else{
$countem=mysql_num_rows($getnotes);
if($countem < 1){
echo(" No Notes For This Quote. "); }else{ while($rows = mysql_fetch_array($getnotes)){ $nID=$rows['ID']; $nby=$rows['author']; $ntitle=$rows['who']; $nmess=$rows['messon']; $ndat=$rows['datnum']; $ndtnum=$rows['dtnum']; echo("
| |||
| Close |