Error Getting Product Info!
Error:" . mysql_error() . "");
}else{
$grow = mysql_fetch_array($getadd);
$gproductname = $grow[0];
$gdescription = $grow[1];
$gprice = $grow[2];
$gunit = $grow[3];
$gminimum = $grow[4];
if($newqty == ""){
$qtymess = "
Please Enter Quantity";
$right = "Not";
$pprod = $gproductname;
$pdes = $gdescription;
$ppr = $gprice;
$pun = $gunit;
$pmin = $gminimum;
}elseif($newqty < $gminimum){
$qtymess = "
Minimum Order: ".$gminimum."";
$right = "Not";
$pprod = $gproductname;
$pdes = $gdescription;
$ppr = $gprice;
$pun = $gunit;
$pmin = $gminimum;
}else{
$additem[] = $gproductname;
$adddesc[] = $gdescription;
$addprice[] = $gprice;
$addunit[] = $gunit;
$addqty[] = $newqty;
$addtot[] = $newqty * $gprice;
}
}
}
}
$result = @mysql_query("SELECT id,productname,description,unit,minimum FROM prices ORDER BY productname");
if (!$result){
echo ("
Error Getting Product Info!
Error:" . mysql_error() . "
");
}else{
while($row = mysql_fetch_array($result)){
$pid[] = $row[0];
$productname[] = $row[1];
$description[] = $row[2];
$unit[] = $row[3];
$minimum[] = $row[4];
}
}
$total = array_sum($addtot);
?>
| Item Code
| Description
| Price
| Unit
| QTY
| Total
|
Q";
$totty = " ";
}else{
$pricey = $addprice[$i];
$totty = $addtot[$i];
}
echo("| " .
"" .
" | $adddesc[$i] | $pricey | $addunit[$i] | $addqty[$i] | $totty |
");
$i = $i + 1;
}
}
if(!empty($addtot)){
echo("| SUB-TOTAL:$said $total |
");
}
?>