check boxes into a table

[pablovicente]

Hi, what i'm trying to do is to store data doing this:

i got check boxes associated with a product for example

memory X
motherboard

monitor X

so if motherboard gets checked it will be inserted into the table, and if everything
is cheked then everything will be inserted

can you give me some guide or aproach to this?

[sabbagh]

Hi!
i don't understand what kind of table u are talking about: <table> or a database table
i think your problem is with the second

<select name="product1">
<optionvalue=1>monitor</option>
<select name="product2">
<optionvalue=1>motherboard</option>
<select name="product3">
<optionvalue=1>memory</option>
.
.
.

<?php
//first connect and select your database
//then:

if($product1==1)
{
$query="insert into mytable (product1,"; $query.="product2, product3)";
$query.="values ('monitor', ";
}else
$query.="''";

if($product2==1)
{
$query.="'motherboard', ";
}else
$query.="''";

if($product3==1)
{
$query.="'memory' ";
}else
$query.="''";

$query.=") where whatever";

$result=mysql_query($result);

//close your connecton
?>

and if you want to introduce in an HTML table remember HTML run in client side, so, you need to call to the same page but now if the value(s) exists then introduce the product(s) into the table

regards!!
José García Sabbagh

[pablovicente]

Well, yes it has to do with a mysql table
and your example is a good guide, i will try to convert it to check boxes thanks a lot!