Looking for a cleaner method

[duckduckgoose]

I should say that this code works, but was hoping someone could show me a simpler, cleaner way of doing it. I'm trying to learn this stuff on my own, and would really appreciate some help:

My form is editable, and this is part of the editing process. The values are retrieved from the database and the radio buttons are pre-checked according to what's stored in my db. Is there a better way?

/* **** Color Name radio buttons, pre-populated if necessary**** */

    $result = mysql_query('SELECT * FROM MyTable WHERE ID = ' . $_GET['colorid'])
    or exit(mysql_error());

    while ($row = mysql_fetch_assoc($result)) {

    if ($row['Color_Name'] == 5) {
            echo '<input type="radio" name="colorname"  value="5" CHECKED>5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0">0';
    } elseif ($row['Color_Name'] == 4) {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4" CHECKED>4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0">0';
    } elseif ($row['Color_Name'] == 3) {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3" CHECKED>3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0">0';
    } elseif ($row['Color_Name'] == 2) {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2" CHECKED>2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0">0';
    } elseif ($row['Color_Name'] == 1) {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1" CHECKED>1';
            echo '<input type="radio" name="colorname"  value="0">0';
    } elseif ($row['Color_Name'] == 0) {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0" CHECKED>0';
    } else {
            echo '<input type="radio" name="colorname"  value="5">5';
            echo '<input type="radio" name="colorname"  value="4">4';
            echo '<input type="radio" name="colorname"  value="3">3';
            echo '<input type="radio" name="colorname"  value="2">2';
            echo '<input type="radio" name="colorname"  value="1">1';
            echo '<input type="radio" name="colorname"  value="0">0';
    }

    } /* **** End of Color Name While Statement **** */

[bpat1434]

Oh my yes..... You can actually do it in 1 simple line for each radio button. It's the ternary operator:

$colorname = '<input type="radio" name="colorname"  value="5"';
$colorname .= ($row['Color_Name'] == '5')?' CHECKED':'';
$colorname .= '>5';
$colorname .= '<input type="radio" name="colorname"  value="4"';
$colorname .= ($row['Color_Name'] == '4')?' CHECKED':'';
$colorname .= '>4';
$colorname .= '<input type="radio" name="colorname"  value="3"';
$colorname .= ($row['Color_Name'] == '3')?' CHECKED':'';
$colorname .= '>3';
$colorname .= '<input type="radio" name="colorname"  value="2"';
$colorname .= ($row['Color_Name'] == '2')?' CHECKED':'';
$colorname .= '>2';
$colorname .= '<input type="radio" name="colorname"  value="1"';
$colorname .= ($row['Color_Name'] == '1')?' CHECKED':'';
$colorname .= '>1';
$colorname .= '<input type="radio" name="colorname"  value="0"';
$colorname .= ($row['Color_Name'] == '0')?' CHECKED':'';
$colorname .= '>0';

echo $colorname;

Or, if you prefer, a loop:

$colorname = '';
for($i=5; $i>=0; $i--)
{
  $colorname .= '<input type="radio" name="colorname" value="'.$i.'"';
  $colorname .= ($row['Color_Name'] == $i)?' CHECKED':'';
  $colorname .= '>'.$i;
}
echo $colorname;

Either one should work.

~Brett