Jump to content

my php store is installed now but not functioning right


socommaster

Recommended Posts

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

";
}

?>

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.