I have a brand new website with an online store. It is up and running with one big problem... when somebody checks out, my administration page isnt recognizing the order. it just says, "No new orders!" the payment goes through to paypal, but i have no idea as to what they ordered. can anyone help? If you can fix it, I will send you $10 through paypal. It shows the orders in the mysql but they arent showing on the admin page. Im so confused and need some assistance.
I dont know if this is where the error is, but Here is what the php is for my order page is:
<?
require_once("../conn.php");
require_once("access.php");
//get the orders
$q1 = "select *, from_unixtime(OrderDate, '%b/%d/%Y') as MyDate from devbg_orders where OrderStatus = 'paid' order by OrderDate desc";
$r1 = mysql_query($q1) or die(mysql_error());
$orders = mysql_num_rows($r1);
if($orders == '0') //we do not have any new orders
{
echo "
<center>No new orders!</center>";
}
else
{
?>
<table align=center width=500 cellspacing=0 cellpadding=0>
<tr style="background-color:black; font-family:verdana; font-size:11; color:white; font-weight:bold">
<td width=40 align=center>ID</td>
<td width=280>Client Names</td>
<td width=80 align=center>Date</td>
<td width=100 align=right>Order Total</td>
</tr>
<?
$col = "#FFFFFF";
//list the orders
while($a1 = mysql_fetch_array($r1))
{
if($col == "#FFFFFF")
{
$col = "#DDDDDD";
}
else
{
$col = "#FFFFFF";
}
echo "<tr bgcolor=$col>\n\t<td align=center>$a1[OrderID]</td>\n\t<td><a href=\"ViewOrder.php?OrderID=$a1[OrderID]\" class=Nav>$a1[billToFirstName] $a1[billToLastName][/url]</td>\n\t<td align=center>$a1[MyDate]</td>\n\t<td align=right>$$a1[OrderTotal]</td>\n</tr>";
}
echo "</table>\n\n
";
}
?>