option list

[Anon]

I want to create a option list from a field in a database divided by /.

This is what I have so far:

echo "<tr><td>";
redFont ("Arial","Sterkte rechts: <br>");
echo "<select name=\"Sterkte rechts\" size=\"1\">";
$result = explode("/",$SR);
while ($row = $result) {
echo "<option value=\"$row[1]\"> $row[0] </option>";

$SR is the field with the contents which I explode with "/"
I think the problem is with the while line but I can only find examples with multiple fields selection from a database.

Can anyone tell me what the exact line must be for the while function.

[Anon]

Hi,

you need to use the 'each' operator to walk thru the array. In your code, $row = $result is always true and you run into an infinite loop.

try:

while($row=each($result)) {
echo $row["value"];
}

or

while(list($key,$val)=each($result)) {
echo $val;
}

Hth

JBL