MySQL and SELECT FORM

Sebow

<?php
foreach ($_POST['farve'] as $key => $farve_output) {
	print $farve_output;
        echo ", ";


}

?>

<form method=POST>
<select name="farve[]" size=10 MULTIPLE>
<option>Grøn</option>
<option>Rød</option>
<option>Blå</option>
</select>

<input type="submit" name="submit" value="submit">
</form>

What I'm trying to do is to make a many to many relation in the MySQL database. Basically, what it handles is colours associated with products. The tables would look something like:

ProductID ---- ProductName
1 --------------- Product A
2 --------------- Product B

ColourID ----- Colour
1 -------------- Green
2 -------------- Red
3 -------------- Blue

ProductID --- ColourID
1 -------------- 1
1 -------------- 2
1 -------------- 3
2 -------------- 3

...Basically for every colour that is added a new row needs to be created in the ProductID - ColourID table. I already made the select form and I already got it to output several 'arrays', what I wonder is, how can I make it handle the values it output as 'individual' values? So that it knows if I have added Grøn (Green), Rød (Red) and Blå (Blue), it will make a seperate row in a MySQL table for each of them. (3 rows)?

Help would be much appreciated

Sebow

...I think I got it to work myself... just figured out that the foreach function handles each array it outputs as a single size (kinda alike to when you make a database query and you output something from a database)...

So... so far I got this (now I will just integrate it into a database, it will be a shitload of codes, but oh well):

<?php
/* oprette forbindelse til databasen */
$db = mysql_connect("", "", "");
mysql_select_db("Sebow_PRODUKTER", $db);

foreach($_POST['farve'] as $Key => $Get_colour) {
    $query = "SELECT ColourID FROM ColourTable WHERE Colour LIKE '$Get_colour'";
    $result = mysql_query($query);
    while($data = mysql_fetch_array($result) )
    {
    echo "<b>" . $data["ColourID"] . "</b>";
    }

echo " " . $Get_colour;
echo "<br>";
}


?>

<form method=POST>
<select name="farve[]" size=10 MULTIPLE>
<?php
/* vi sender en forespørgsel til en tabel og siger hvilke data den skal hente osv. */
$query = "SELECT Colour FROM ColourTable"; 
$result = mysql_query($query);
while($data = mysql_fetch_array($result) )
{
echo "<option>" . $data["Colour"] . "</option>";
}

?>
</select>

<input type="submit" name="submit" value="submit">
</form>

...But if anyone knows a better (quicker, simpler) approach, then that would still be much appreciated. O_o

jmosterb

How about removing the db connection info from the code in case anyone less nice is reading it...? 🙂