GENERATE <option> menu from MySQL

[perrio]

I'd like to generate a custom option pop up menu

I have the values in an array from MySQL

Now how can I assign html characters with the values from the db as a string to 1 variable (which will be passed out to my script for printing)?

here is the script i was working with;;

$result = mysql_query($q,$c);

while ($x < mysql_num_rows($result)):
$H = mysql_result($result, $x, 'spec_val');
$t[$x] =$H;
$x++;
endwhile;

//this is where it gets difficult

$string1[4] = " &lt; option value &gt; thevalue ";
print $string1["4"];
//for($i =0; $i < sizeof($t);$i++)
//{
//$info[$i] = mysql_fetch_array($result);
//}
//for($k=0 ; $k < sizeof($info); $k++)
//{
//$t = $t."<option value='".$info["spec_val"]."'>".$info["$k"];
//}

mysql_close();

print $t;
?>

[AliasZero]

i can't help you out with what you want to do partially because you must must must must use descriptive variable names, otherwise in 6 months time you'll find it impossible to read, and so will everyone else now also format it so it's readable 😃

[Thatsmej]

i love those capital letters you use Oo

back to you again