Forum Moderators: coopster

Message Too Old, No Replies

How to delete?

need help

         

xxdejavu2

11:31 am on Apr 14, 2004 (gmt 0)



hi all,how to delete mysql row at php with checkbox?
thanks before.

HelenDev

12:18 pm on Apr 14, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I use a link rather than a checkbox...

$getuserdata = mysql_query("SELECT * FROM cart WHERE UserID='$userinfo'");

if ($myproducts = mysql_fetch_array($getuserdata)) {

do {
print('<p>'.$myproducts[Manufacturer].' '.$myproducts[Model].'<a href="cart.php?deleteme='.$myproducts[ID].'">remove item</a>');

} while ($myproducts = mysql_fetch_array($getuserdata));

}

// then in the script where the cart is pointing (or earlier on in same page if it points to itself)...

if (isset($deleteme)){
$deleteitem = mysql_query("DELETE FROM cart WHERE ID='$deleteme'");
}

DrDoc

4:33 pm on Apr 14, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



...and Welcome to Webmaster World!