require_once("../database.php");
require_once("adminfuncties.php");
$q1 = "select *, from_unixtime(OrderDate, '%b/%d/%Y') as MyDate from oneshop_bestellingen where OrderStatus = 'paid' order by OrderDate desc";
$r1 = mysql_query($q1) or die(mysql_error());
$orders = mysql_num_rows($r1);
if($orders == '0')
{
echo "
ID | Klant naam | Datum | Totaal |
$a1[OrderID] | \n\t$a1[BillToFirstName] $a1[BillToLastName] | \n\t$a1[MyDate] | \n\t$a1[OrderTotal] | \n