socommaster Posted July 14, 2007 Share Posted July 14, 2007 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 "; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.