Okay, I have a cart script but for some reason it won't add the item to the cart. Every time I click Add Item To Cart it takes me to the cart and says I have nothing in it! Please help me!

Cart.php

PHP Code:

<?
    include("common.php");
    require_once("templates/HeaderTemplate.php");
    switch ($a){
        case "add":
            AddItem($_GET["item"],1);
            $totalCost = ShowCart();
            break;
        case "update":
            $myqty = $_REQUEST['qty'];
            while(list($k,$v) = each($_REQUEST[ids])){
                $qty = $myqty[$k];
                if( $qty == 0 ){
                    RemoveItem($v);
                }else{
                    UpdateItem($v, $qty);
                }
            }
            $totalCost = ShowCart();
            break;
        case "remove":
            RemoveItem($_GET["item"]);
            $totalCost = ShowCart();
            break;
        default:
            $totalCost = ShowCart();
            break;
    }
    require_once("templates/FooterTemplate.php");
    
    function AddItem($item,$qty=1){
        //get the product info
        $q1 = "select * from items where ItemID = '$item' ";
        $r1 = mysql_query($q1) or die(mysql_error());
        $a1 = mysql_fetch_array($r1);
        //add to cart
        $chk = mysql_query("SELECT * FROM cart WHERE OrderID='".GetCartId()."' AND ItemID='$a1[ItemID]'");
        if( mysql_num_rows($chk) > 0 ){
            UpdateItem($item,2);
        }else{
            $q2 = "insert into cart set 
                                        OrderID = '".GetCartId()."',
                                        ItemID = '$a1[ItemID]',
                                        ItemPrice = '$a1[ItemPrice]',
                                        ItemQty = '$qty',
                                        ItemTotal = '$a1[ItemPrice]' ";
            mysql_query($q2) or die(mysql_error());
        }
    }
    function UpdateItem($item,$qty){
        //get the product info
        $q1 = "select * from items where ItemID = '$item' ";
        $r1 = mysql_query($q1) or die(mysql_error());
        $a1 = mysql_fetch_array($r1);

        //add to cart
        $q2 = "UPDATE cart SET ItemQty = '$qty' WHERE OrderID = '".GetCartId()."' AND ItemID = '$a1[ItemID]'";
        mysql_query($q2) or die(mysql_error());
    }
    function RemoveItem($item){
        mysql_query("DELETE FROM cart WHERE OrderID= '" . GetCartId() . "' and ItemID = '$item'");
    }
    function ShowCart(){
        //get the cart content
        $q1 = "select * from cart, items where cart.OrderID = '".GetCartId()."' and cart.ItemID = items.ItemID order by items.ItemName";
        $r1 = mysql_query($q1) or die(mysql_error());
        if(mysql_num_rows($r1) == '0'){
            include_once("templates/EmptyCartTemplate.php");
        }else{
            $col = "white";
            while($a1 = mysql_fetch_array($r1)){
                if($col == "white"){
                    $col = "dddddd";
                }else{
                    $col = "white";
                }
                $a1[ItemTotal] = ( $a1[ItemPrice] * $a1[ItemQty] );
                $rows .= "<tr bgcolor=\"$col\">\n\t<td class=BlackLink>$a1[ItemName]</td>\n<td align=right>$aset[currency_sign] $a1[ItemPrice]</td>\t\n\t<td align=center>\n\t\t<input type=text size=3 name=\"qty[]\" value=\"$a1[ItemQty]\">\n\t\t<input type=hidden name=\"ids[]\" value=\"$a1[ItemID]\">\n\t</td>\n\t<td align=right>$aset[currency_sign] $a1[ItemTotal]</td>\n</tr>\n\n";
                $order_total = $order_total + ( $a1[ItemPrice] * $a1[ItemQty] );
            }
            $order_total = number_format($order_total, 2, ".", ",");
            include_once("templates/ViewCartTemplate.php");
        }
    }
?>

ViewItemTemplate.php

PHP Code:

<br>

<table align=center width=400 border=0>
  <tr> 
    <td width="250" valign=top> <span class=ItemTitle> 
      <?=$a1[ItemName]?>
      </span><br>
<br>
      <a class=CategoryName href="categories.php?CategoryID=<?=$a1[ItemCategory]?>"> 
      <?=$a1[CategoryName]?>
      </a><br> <br>
      <span class=PriceClass><strong>Price:</strong> 
      <?=$aset[currency_sign]?>
      <?=$a1[ItemPrice]?>
      </span> <br>
      <p><br>
        <strong>Demo:</strong> <strong> 
        <?    if(($a1[Demo]) == 1){    ?>
        <a href="<?=$a1[DemoURL]?>" target=_blank> 
        <?=$a1[DemoURL]?>
        </a> </STRONG><font size="1"><BR>
        (Will open in a new window)</font> 
        <?    }else{    ?>
        <STRONG><font color="#FF0000">No demo available</font> 
        <?    }    ?>
        </strong></p>
      <p>&nbsp;</p></td>
  </tr>
  <tr>
    <td class=ItemDesc> 
      <?=nl2br($a1[ItemDesc]);?>
    <p>&nbsp;</p></td>
  </tr>
  <tr> 
    <td width=400 class=ItemDesc><table width="391" border="0" cellspacing="0" cellpadding="0">
        <tr> 

            <!-- ADD TO CART BUTTON -->
          <td width="133"><div align="center"><a href="cart.php?a=add&item=<?=$a1[ItemID]?>"><img src="images/addcart.gif" width="116" height=21 alt="Add to cart" border=0></a></div></td>
            <!-- END ADD TO CART BUTTON -->

          <td width="133"><div align="center"><a href="cart.php"><img src="images/viewcart.gif" width="116" height=21 alt="View cart" border=0></a></div></td>
        </tr>
      </table></td>
  </tr>
</table>

include

ini_set('display_errors','On');

at the top of commpn.php. Post any warnings and notices. There's a bunch of places where stuff can be going wrong, error display will help.

Okay, I will try that.

Thanks.

Still doesn't work! I looked over my common.php too. Please if anyone can help! (btw sorry for the double post)

What exactly does not work as you expect?

I'm so thankful to found this forum, and thanks also for these infomation!

When I click add to cart it takes me to the cart and says I have nothing in it.
My add to cart URL is /cart.php?a=add&item=<?$a1=[ItemID]?>
Which with my test item it would look like this -
/cart.php?a=add&item=88