I've got some checkboxes to colect some data the problem is that i want to store a product name in a table and a product tipe at the same time.
how can i get to do that the script is this (well, part of it)
-the checkbox:
<input name="list[]" type="checkbox" value="1">product
-the insert part:
$count=count($list);
for ($i=0; $i<$count; $i++)
{
$sql = "INSERT INTO tablename VALUES ('','$user','$list[$i]',curdate(),'$xxvariable','$xyvariable')";
$result = mysql_query($sql);
}
-result that i'm looking for:
id|product|type of product
1 2 3
thanks a lot!
