Array

[unidox]

My code:

 

require_once ("files/roster.php");
	$selecta = "Member&Co-Leader&Leader&Recruit";
	$selectb = mysql_fetch_array(MYSQL_QUERY("SELECT * FROM cp_divisions ORDER BY division ASC"));

 

The select b goes in a drop down, and I would like it to drop as many divisions are in the db, but theres only 1 and it says array. How do I echo the right thing?

[pocobueno1388]

Try mysql_fetch_assoc() instead of array.

 

Show the code to your drop-down.

[unidox]

This is my drop down code:

 

if ($fieldtype[$i] == "select") {
					echo "<select name=\"" . $field[$i] . "\">";
					$options = explode("&",$selectb);
					for ($o = 0; $o < count($options); $o++) {
					echo "<option value=\"" . $options[$o] . "\"";
						if ($mysql_values != '') {
							if ($mysql[$i] == $options[$o]) {
								echo " selected";
							}
						}
					echo ">" . $options[$o] . "</option>";
					}

[unidox]

bump