Hi All,
I'm a newbie programmer that just started learning PHP. I would really appreciate if you can help me out with this issue that I have for about 2 days and couldn't solve it.

Here is the code that I am using to retrieve data from the database and show it as a nice clean table with a check box beside each item:

Code PHP:
<?php
 
$con = mysql_connect("database", "usename", "password");
 
if (!$con) {
die('Connection Failed: ' . mysql_error());
}
 
 if (mysql_select_db("database",$con)){
   if ($qry= mysql_query("select * from INVENTORY")){
        $num=mysql_numrows($qry);
        mysql_close();
}
}
 
?>
<html>
<body>
<form method="POST">
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th>Item</th>
<th>Description</th>
<th>Price</th>
<th>Picture</th>
<th>Selection</th>
</tr>
 
 
<?php
while ($row=mysql_fetch_array($qry)) {
 
$f1=$row['Item_Image'];
$f2=$row['Inventory_ID'];
echo "<tr><td>";
 
echo $row['Item_Name'];
 
echo "</td><td>";
 
echo $row['Item_Details'];
 
echo "</td><td>";
 
echo $row['Item_Price'];
 
echo "</td><td>";
?>
<img src="http://zenit.senecac.on.ca/~php701_121sa03/assign2/<?php echo $f1; ?>" alt= "<?php echo $f1; ?>"  width="100" height="100" />
 
<td> <input type="checkbox" name= <?php echo $f2; ?>  /></td>
 
<?php
echo "</td></tr>";
}
echo "</table>";
 
?>
</form>
<form action="cart.php" method="POST">
<input type="submit" name="submit" value="Add to the Cart">
</form>
 
</body>
</html>


So What I wanna do is that when I press submit button, it takes the items that is checked and put them in a temporary cart
this is the page that is called if I press submit buttom, i make a temporary cart and I am trying to input the values that is set to the checkboxes into the temp cart but I have no idea how to do it ...

I tried to use cookie to save the values that selected but couldn't sort that out , I need help ...

Code PHP:
<?php
 
$con = mysql_connect("database", "username", "password");
 
if (!$con) {
 
die('Connection Failed: ' . mysql_error());
 
}
 
$userid = $_COOKIE['loguser'];
 
$myquery= ("CREATE TABLE " . $userid . "_CART (Cart_Item_ID int auto_increment, PRIMARY KEY(Cart_Item_ID), Item_ID int not null, FOREIGN KEY(Item_ID) REFERENCES INVENTORY(Inventory_ID), Added_On Timestamp default CURRENT_TIMESTAMP)");
 
$userid = $_COOKIE['loguser'];
 
if (isset($_POST['submit'])){
 
 if (mysql_select_db("database",$con)) {
 
        if ($qry = mysql_query($myquery,$con)) {
 
                $myquery1= ("insert into ". $userid . "_CART(Item_ID) select Inventory_ID from INVENTORY where INVENTORY.Inventory_ID = ". $_POST;
 
        } else {
 
                die('Database Query Error: ' . mysql_error());
 
        }
 
  }
 
}
 
?>


here is my database tables one is inventory, and the other one is temporary cart , Im trying to input the value of inventory_ID into the Item_ID where the check boxes is selected ....

Inventory_id is foreign key of temp cart and primary key of Inventory table

+--------------+-----------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------+------+-----+-------------------+----------------+
| Cart_Item_ID | int(11) | NO | PRI | NULL | auto_increment |
| Item_ID | int(11) | NO | MUL | | |
| Added_On | timestamp | YES | | CURRENT_TIMESTAMP | |
+--------------+-----------+------+-----+-------------------+----------------+
3 rows in set (0.00 sec)

mysql> desc INVENTORY;
+--------------+----------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------+------+-----+-------------------+----------------+
| Inventory_ID | int(11) | NO | PRI | NULL | auto_increment |
| Item_Name | varchar(40) | NO | | | |
| Item_Details | varchar(250) | YES | | NULL | |
| Item_Image | varchar(25) | YES | | noIMG.jpg | |
| Item_Price | float unsigned | YES | | 0 | |
| Added_On | timestamp | YES | | CURRENT_TIMESTAMP | |
+--------------+----------------+------+-----+-------------------+----------------+
6 rows in set (0.00 sec)

Please advise me what to do ?
If only you can tell me how to get the checkbox values and show it in the cart page as an echo it will solve lots of my issues as well...