drop down menu

[hmark]

I'm trying to insert a dropdown menu on my webpage. THis is what I have right now:

 

[code=php:0]
<tr>
<td>System:</td>
<td><select name="system">
<option value=""> </option>
<?
$arr_system = getFldArray("system");
foreach ($arr_system as $f){
	print "<option value=\"$f\">$f</option>";
}
?>
<td>
</tr>

[/code]

 

When i execute this, I get varchar(20) as a option. Anyone have any suggestions? I know very very very little php and mysql. I appreciate any help. I hope I posted enough info (and that I posted it correctly  thanks.

[jeremy0]

what is getFldArray?

 

 

[hmark]

I defined it as:

 

function getFldArray($f){
$q = "describe experts $f";
$res = run_query($q);
$row = mysql_fetch_array($res);
$rt = $row['Type'];
$rt = preg_replace('/enum\(\'/', '', $rt);
$rt = preg_replace('/\'\)/', '', $rt);
$arr = explode('\',\'',$rt);
sort($arr);
return $arr;
}

[jeremy0]

is this still an issue?  Looking at your reply tonight, it looks like the mysql query is doing what it is told - list all the fields and their type(s) - which is why you end up with 'varchar(20)' - that's the data definition of that field.

 

 

[hmark]

Yes, this is still an issue. Do you know how i can correct this properly? Thank you.

[jeremy0]

what I was trying to say earlier was, the mysql query you are running is saying 'describe this field', and the description of those fields in the database is 'varchar[20]'.  You need to run a query on the actual data, i.e. 'select type from experts..' or whatever data you are trying to fetch from the sql statement....

[clay1]

This is what I use for one

 

<select name="market">
		<option value="none" selected>Please select a market</option>
		<?php

//for each row we get from mysql, echo a form input
while ($row = mysql_fetch_array($result)) {
echo "<option value=\"".$row['market']."\">{$row['market']}</option>\n";
}
?> </select>

 

$result is just a select all on the markets table