This is the inquiry details of the particular customer on which you clicked. To take the print of the inquiry click on the Print Inquiry to print the inquiry.
include ("backlink-inc.php")?>
View Inquiries
$qrycust=mysql_query("select * from tbl_inqcust where Login='".$_REQUEST["InqID"]."'") or die(mysql_error());
if(mysql_num_rows($qrycust)>0){
$rs=mysql_fetch_array($qrycust);
?>
Inquiry
ID
Inquiry
Date
Customer Information
Full Name
Company
Phone
Email
Address
I Want to
Comments
}
?>
Inquiry Detail
$qryprd=mysql_query("select * from tbl_inq where OrderID='".$_REQUEST["InqID"]."' and instatus='o'") or die(mysql_error());
if(mysql_num_rows($qryprd)>0){
?>
Product Description
Qty
$tqty=0;
while($rs=mysql_fetch_array($qryprd)){
$tqty=$tqty+$rs["qty"];
$qryprd1=mysql_query("select * from tbl_items where ItmID='".$rs["itmid"]."' and lngid='".$rs["lngid"]."'") or die(mysql_error());
$rs1=mysql_fetch_array($qryprd1);
?>
if($rs["pSize"]<>''){
$sizeqry=mysql_query("select * from tbl_sizes where sizeid='".$rs["pSize"]."'order by sizeid")or die(mysql_error());
if(mysql_num_rows($sizeqry)>0){
$i=0;
while($rs3=mysql_fetch_array($sizeqry)){
?>
Size:
}
}
}
?>
// if($rs["pColor"]<>''){
// $qrycolorprd=mysql_query("select * from tbl_pcolor where ItmID='".$rs["itmid"]."' and colorname='".$rs["pColor"]."'") or die(mysql_error());
// if($qrycolorprd){
//$rows1=mysql_num_rows($qrycolorprd);
//if($rows1>0){
//$rs3=mysql_fetch_array($qrycolorprd);
// $img1=$clrimgs.$rs3["c_simg"];
// }
// }
?>
// }
// else{
// $img1=$itmimgs.$rs1["ItmImg"];
// }
?>