Get remove to work on first and not second click

[mancroft]

I am deleting an item from a shopping cart by using:

<a href=&quot;ShoppingBag.php?removeitem=<?php echo $row[&quot;cartId&quot;]; ?>&quot;><img src=&quot;Del.jpg&quot;></a>

in conjunction with:

if (!empty($_GET['removeitem'])) { 
RemoveItem($_GET['removeitem']); 
}



 function RemoveItem($cartId)
 {
  global $dbServer, $dbUser, $dbPass, $dbName;

  // Get a connection to the database
  $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName) or die(mysql_error());
  
  mysql_query("delete from cart where cookieId = '" . GetCartId() . "' and cartId = $cartId") or die(mysql_error());
 }

which works BUT it only deletes if you click on the remove image file TWICE.



Is there a way to get this to work on the first click?



Thanks.

 

[Bastien]

could it be that you are merely seeing the cached page in the browser? check the db after the button is clicked once and see if the data is still present.

also try echoing out the sql statement before execution to see if it is correct

maybe change the code to this:

function RemoveItem($cartId)
                          {
                           global $dbServer, $dbUser, $dbPass, $dbName;

                           // Get a connection to the database
                           $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName) or die(mysql_error());
                           
                          $sql="delete from cart where cookieId = '" . GetCartId() . "' and cartId = $cartId") 
                          
                         echo $sql;  
                       
                          $result=mysql_query($sql) or die(mysql_error());
                          }

Bastien

cat, the other other white meat

 

[mancroft]

Problem solved. Thanks.