PHP question on an order page for my store

[socommaster]

i have a website with a store.  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?

 

Here is what the php is for my orders 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 "<br><br><center>No new orders!</center>";

}

else

{

?>

<br><br>

<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]</a></td>\n\t<td align=center>$a1[MyDate]</td>\n\t<td align=right>$$a1[OrderTotal]</td>\n</tr>";

}

 

echo "</table>\n\n<br><br>";

}

 

?>

 

 

 

[infid3l]

Are the orders actually in the database, though?

 

And please use the code and full <?php tags.

 

edit: also, is there supposed to be a comma in:

 

$q1 = "select *, from_unixtime

 

?

[socommaster]

yep... 8 orders in the database