|
Match File: Eco-$mart_Product_Prices__.xls
|
|
");
echo(" |
| Item | " .
"sku | " .
"List | " .
"Retail | " .
"Special | " .
"Dealer | " .
"Dealer_Lo | " .
"Distributor | " .
"Cost | " .
"Unit | " .
"Lo_Units | " .
"Case | " .
"Minimum | " .
"Updated | " .
"Description | " .
"
");
$getit = mysql_query("SELECT item,sku,list,retail,special,dealer,dealer_lo,distributor,cost,unit,lo_units,cs,min,up_date,description FROM price ORDER BY item");
if(!$getit){
echo("Could not Retrieve Price List
".mysql_error()."
");
}else{
$numrows = mysql_num_rows($getit);
if($numrows < 1){
echo("
| No Prices Available. Data base table is empty. |
");
}else{
while($row = mysql_fetch_array($getit)){
echo("| $row[0] | $row[1] | $row[2] | " .
" $row[3] | $row[4] | $row[5] | " .
" $row[6] | $row[7] | $row[8] | " .
" $row[9] | $row[10] | $row[11] | " .
" $row[12] | $row[13] | $row[14] |
");
}//while
}//else
}//bigelse
?>
