[SOLVED] specific output

[Lambneck]

i have an example form submitting data to a mysql database

 

<form>
<INPUT TYPE="radio" Name="color" VALUE="Red">Red<br>
<INPUT TYPE="radio" Name="color" VALUE="Green">Green<br>
<INPUT TYPE="radio" Name="color" VALUE="Blue">Blue<br>
<INPUT TYPE="text" NAME="color_comments" SIZE=30>
<INPUT TYPE="Submit" VALUE="Submit Message" Name="submit">
</form>

 

I also have separate pages (red.php, green.php, blue.php) that will display the form data that users submit based upon which color the user chose with the radiobuttons. for example all the submissions that had "Red" selected would be displayed in the page "red.php" and so on.

My question is how do i get "red.php" to display all and only submissions that had the "Red" radiobutton selected?

 

[DarkWater]

...What?

[Lambneck]

so every form submission goes to the same database.

but not every submission is the same.

some people select blue, some red, some green.

i have three webpages representing each color.

red.php

blue.php

green.php

 

red.php would display all the submissions that had the color red selected in the form

blue.php would do the same with blue

etc.