Session Wont Die

[Mero]

This is the end code of my newly written shopping cart. At the end I want to erase everything in the cart table and kill the session. Then I go back to the start page where I want a new session to start.

It aint working... Everything I can find says this should clear the session variables and the session id.

Any help is greatly appreciated.

$sql = "DELETE FROM KC_CAMPUS.CART WHERE COOKIE_ID = '$s_id'";

$stmt = OCIParse($connect, $sql);
OCIExecute($stmt);

session_unset();
session_destroy();

HEADER ("LOCATION: home.php");exit;

?>

[bobthedog]

How do you mean it doesn't work?

[drawmack]

did you call session_start earlier in the script?

also if you ware calling session write close after this it could give a problem as the variables are still in $_SESSION. Try this

<?
session_start(); //needs to be anywhere before the next line
session_unset();
$_SESSION = array();
session_destroy();
?>