[airy]

Anyone know what to write to delete the whole row of particular id at datbase

case 'delete':
		if ($cart) {
			$items = explode(',',$cart);
			$newcart = '';
			foreach ($items as $item) {
				if ($_GET['id'] != $item) {
					if ($newcart != '') {
						$newcart .= ','.$item;
					} else {
						$newcart = $item;
					}
				}
			}
			$cart = $newcart;
		}

[no2pencil]

Deleting from the database is a lot more dangerous than marking items as non-active. But if you must, you shouldn't EVER plug GET array variables into your sql string. But if you must do that, you can use the following :

delete from table_name where id='$_GET[id]';

Though I would recommend you learn from the provided statement, & do it safely & correctly.

[airy]

so how do i use that in the following codes?

<td><?echo '<br /><a href="cart.php?action=delete&id='.$row['pd_id'].'">Remove</a></li>';?></td>

[no2pencil]

Since I have to guess at your database layout, I would assume that $row['pd_id'] your defining id for the row, so :

delete from table_name where id='$row[pd_id]';

If that isn't correct, we need to see how your database is setup.

Quote

Though I would recommend you learn from the provided statement, & do it safely & correctly.