searchreceiptsresponse.php

Shopping Cart

<?
require("Cart.php");
Brand();
DBInfo();
mysql_connect("$DBHost","$DBUser","$DBPass");
blueFont("Arial","<b>Select the proper order to continue...</b><br><br>");
echo "<ul>";
if ($criteria == "order") {
$result=mysql("$DBName","SELECT BuyerID,OrderNumber,PayMethod,CCType,Contact,Name FROM Buyers WHERE OrderNumber = '$OrderNumber' ORDER BY OrderNumber");
while ($row = mysql_fetch_row($result)) {
$BBI=$row[0];
$BON=$row[1];
$BPM=$row[2];
$BCT=$row[3];
$BCo=$row[4];
$BNa=$row[5];
fontFace("Arial","<li><a href=\"./receipt.php?BI=$BBI&ON=$BON&PM=$BPM&CT=$BCT&Co=$BCo\">$BNa - Order Number <b>$BON</b></a></li>");
	}
} elseif ($criteria == "name") {
$result=mysql("$DBName","SELECT BuyerID,OrderNumber,PayMethod,CCType,Contact,Name FROM Buyers WHERE Name LIKE '%$User%' ORDER BY OrderNumber");
while ($row = mysql_fetch_row($result)) {
$BBI=$row[0];
$BON=$row[1];
$BPM=$row[2];
$BCT=$row[3];
$BCo=$row[4];
$BNa=$row[5];
fontFace("Arial","<li><a href=\"./receipt.php?BI=$BBI&ON=$BON&PM=$BPM&CT=$BCT&Co=$BCo\">$BNa - Order Number <b>$BON</b></a></li>");
	}
} else {
$result=mysql("$DBName","SELECT BuyerID,OrderNumber,PayMethod,CCType,Contact,Name FROM Buyers WHERE Date LIKE '%$Year%-%$Month%-%$Day%' ORDER BY OrderNumber");
while ($row = mysql_fetch_row($result)) {
$BBI=$row[0];
$BON=$row[1];
$BPM=$row[2];
$BCT=$row[3];
$BCo=$row[4];
$BNa=$row[5];
fontFace("Arial","<li><a href=\"./receipt.php?BI=$BBI&ON=$BON&PM=$BPM&CT=$BCT&Co=$BCo\">$BNa - Order Number <b>$BON</b></a></li>");
	}






}
echo "</ul>";

adminFooter($Relative);
?>