Need Help With Session Variable

[olygolfer]

Hi I need some advice. I am creating a script that displays all the items in a cart based on a the session id, the steps are explained below.

The user adds to cart and then a new row is created in mysql with a unique orderid.

The orderid is then stored in the session id.

What i am looking to do is create a search function that displays the cart items based in the orderid. I have created the code below but appaears with diiferent errors when i try run it.
Mentioning something about T-Variables.

Can Anyone help

small code snippet it explains error appears on this line

$result = mysql_query ("Select product, price from productsordered where orderid = $HTTP_SESSION_VARS['orderid']",$db);

[jpmoriarty]

break out of the string before you try to get to an array - it's not too reliable. And always, always, always define your sql statement first or you'll run into problems like the one that you just have:

$sql = "select product, price from productsordered where orderid = '".$HTTP_SESSION_VARS['orderid']."'";
$result = mysql_query ($sql,$db); 

[epimeth]

can we see some code please? and what, exactly is the error?

[dalecosp]

I'd say Mr. Moriarty hit it, but I could be wrong. I just came to add an opine --- it generally builds a cleaner cart to do all the work in the session, up to the point the order is complete. Why write anything to the db when the customer could decide to change his/her mind at any time? If you write every item added to the cart to the db, you've got to delete it from the db when 'remove item' is clicked, and that means writing PHP to delete from the SQL, so why not you keep everything in the $_SESSION array until you're ready to submit the order to the warehouse (or whatever.....)