passing sessions (and arrays) through pages

[chrislead]

I have run a query from my ODBC connection and successfully displayed the records in the database. However, according to each record produced, how can I; through the use of a submit button; add the product name and price etc to the session and call them results on another page. I know that this process can be acomplished by this...

$name = $POST['name'];
$SESSION['name'] = $name;
echo $_SESSION['name'];

...which grabs the data inputted through a form, but how do I do a similar sort of thing but with the individual results of my query.

Or would this be something to do with arrays? if so please advise on a way to declare and (through a submit button), add the query results to the array and aquire them later.

thanks.

[devinemke]

$result = odbc_exec($conn, 'SELECT * FROM table where id = ' . $_POST['id']);
while ($row = odbc_fetch_array($result)) {$_SESSION[$row['id']] = $row;}

[chrislead]

Thanks very much.

I had a go, and expanded it slightly, I instead used hidden fields and assigned to each, the vaule of each field from my database, it works great!

However, now I am rather worried, because I put the selected item in a table on a seperate page. kind of like a shopping cart. But I want the items to stay in that table while the user keeps looking around the site. Then, by selecting another item from the database, the same actions are preformed and that item is added to the cart, but at the moment, I suspect the last item to dissapear. Any solutions?

Thanks again.