QUOTATION
SENT ( $Sel_user = mysql_query("select * from users where UserName='$s_name'");
$srow = mysql_fetch_array($Sel_user);
$Sel_quot = mysql_query("select * from quoterequests where FromID='$srow[CustomerID]'");
$coun = mysql_num_rows($Sel_quot);
echo $coun;?> ) |
QUOTATION
REPLY RECEIVED
(
$Sel_user1 = mysql_query("select * from users where UserName='$s_name'");
$srow1 = mysql_fetch_array($Sel_user1);
$Sel_quot1 = mysql_query("select * from quotesubmits where ToID='$srow1[CustomerID]' and status='New'");
$coun1 = mysql_num_rows($Sel_quot1);
echo $coun1." New";?> ) |
SENT
P/O (
$Sel_user2 = mysql_query("select * from users where UserName='$s_name'");
$srow2= mysql_fetch_array($Sel_user2);
$Sel_quot2 = mysql_query("select * from quotesubmits where ToID='$srow2[CustomerID]' and status='Old'");
$coun2= mysql_num_rows($Sel_quot2);
echo $coun2;?> )
|
INVOICE
RECEIVED
( $Sel_user4 = mysql_query("select * from users where UserName='$s_name'");
$srow4= mysql_fetch_array($Sel_user4);
$Sel_quot4 = mysql_query("select * from invoices where ToID='$srow4[CustomerID]' and status='New'");
$coun4= mysql_num_rows($Sel_quot4);
echo $coun4." New";?> ) |
INVOICE
CONFIRMED ( Total $Sel_user14 = mysql_query("select * from users where UserName='$s_name'");
$srow14= mysql_fetch_array($Sel_user14);
$Sel_quot14 = mysql_query("select * from invoices where ToID='$srow14[CustomerID]' and status='Old'");
$coun14= mysql_num_rows($Sel_quot14);
echo $coun14;?> ) |
|
|