Select

[unidox]

My Code:

 

if ($fieldtype[$i] == "selectb") {
                            $r = mysql_fetch_array(mysql_query("SELECT * FROM `cp_divisions` ORDER BY division_id DESC"));
                    		$divis[] = $r['division'];
                            echo "<select name=\"" . $field[$i] . "\">";
                        for ($o = 0; $o < count($r); $o++) {
                        ?>
                              <option value=
                              "<?=$divis[$o]?>">
                              <?=$divis[$o]?>
                              </option>
                              </select>
                			<?
                            }
				}

 

Works, but I have more than 1 in the table, how do I echo more than one?

[unidox]

bump

[BlueSkyIS]

First, only use mysql_query once:

 

$result = mysql_query("your sql here").

 

Then loop over the result, using mysql_fetch_array() each time, ala:

 

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

 

  // Do something with $row here.

 

}