Passing Variables Please Help

[olygolfer]

Hi everyone i am in need of some help.

I am developing a shopping cart with php and mysql, I have the products stored in a table in the database. I set a sql query that selects all the products under a certain catagory and then prints individual product row out in a continous order for that catagory.

ie.

sql query returns variables $product and $price

rows are then printed out

product intel processor
price $20.00

product AMD
price $30.00

What i am idealy looking for is for the php to create a unique form for each row printed that contains a button linking to the addtocart.php file and that contains that rows variables in a hidden field hidden

Once the variables for that product are collected the addtocart.php file can add a row to an orders table on mysql

Can you help me to create each form and attach thevariables to it.

[nnichols]

while ($row=mysql_fetch_array($res)) {
echo '<form method="post" action="addtocart.php">';

// include vars to be passed as hidden fields
echo '<input type="hidden" name="product_id" value="'.$row['product_id'].'">';
echo '<input type="hidden" name="product_name" value="'.$row['product_name'].'">';
echo '<input type="hidden" name="product_price" value="'.$row['product_price'].'">';

echo 'Product: ' . $row['product_name'] . '<br>';
echo 'Price: ' . $row['product_price'] . '<br>';
echo 'Quantity: <input type="text" size="1" name="product_quantity"><br>'
echo '<input type="submit" value="Add to cart"></form><br><br>';
}

[olygolfer]

just like to say thanks for your help. This sorts alot of problems out.