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 "; } ?> Link to comment https://forums.phpfreaks.com/topic/59900-my-php-store-is-installed-now-but-not-functioning-right/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.