socommaster

How do I check the configuration?

I figured it out, the order status wasnt saying paid so the it wasnt being recognized on the orders.php screen. By manually putting paid next to the orders in the mysql the orders would appear on the admin page. Thanks for everybodys help on this. Now does anyone know how to make it so "paid" shows up next to the order status without me having to go in to it manually and change it?

I used it with the original script.

Still no luck. There are 8 orders in the system, but the administration page is still showing 0 open orders. And the adminstration page pulls up the orders.php Any other suggestions?

Thanks for the info... I gave it a try, but now when I go into the admin to check orders it's blank and doesnt even list "there are no orders". Any other suggestions?

I can go into the database and retrieve the info: OrderID 1 SubTotal 0 ShippingPrice 14.99 SalesTax 0 OrderTotal 45.99 ShipToFirstName Joe ShipToLastName Blow ShipToAddress1 123 madeupstreet ShipToAddress2 ShipToCity Beverly Hills ShipToCountry USA ShipToState CA ShipToPhone 213 555 1212 ShipToZIP 91210 BillToFirstName Joe BillToLastName Blow BillToAddress1 123 madupstreet BillToAddress2 BillToCity Beverly Hills BillToState CA BillToCountry USA BillToZIP 90210 BillToPhone 213 555 1212 ClientEmail non@nmljsdkdjlfkjalkj.com CC_type CC_number 0 CC_sec 0 ExpMonth 0 ExpYear 0 OrderStatus OrderDate 1161529979 I noticed the order status isnt saying paid and the order date looks funky. Problem there?

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 "; } ?>

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? I dont know if this is where the error is, but 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 " <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 "; } ?>

yep... 8 orders in the database

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>"; } ?>