switch

Hi have this code working on my site but I want it to detect and switch from a sql query.. can this be done?

PHP Code:

---

<select name="club_id">
        <?php

        switch ($club_id)
        {
            case "2":
                $opt2 = " selected ";
                break;
            case "3":
                $opt3 = " selected ";
                break;
            case "4":
                $opt4 = " selected ";
                break;
            case "5":
                $opt5 = " selected ";
                break;
            case "6":
                $opt6 = " selected ";
                break;
            case "8":
                $opt8 = " selected ";
                break;
            case "9":
                $opt9 = " selected ";
                break;
            

        }

    ?>

      <option <?php echo $opt2; ?> value="2">Auckland</option>
                  
    </select>

---

Can you possibly explain a little more. I don't really understand what you mean.

Quote:

---

Originally posted by visualAd
Can you possibly explain a little more. I don't really understand what you mean.

---

sure, I the code I posted does a query from the sql database and switches the drop down box!!

However I have added all the option by hand, I want it to do this for all options on my table... would a loop work?

The usual way is

PHP Code:

---

for($i = 0; $i < count($options); ++i) {
  echo "<option value=\"$i\"".($club_id == $i ? ' selected="selected"' : '').
    '>'.$options[$i]."</option>\n";
} 


---