Nested While loop

[dstefani]

Hello,

I am trying to build rows from a query (easy)
But in each row, I need to have a form that contains
a select list. The select list has to be filled by
another query.

Maybe I'm just too tierd, how can I pass all of the
option tags to my row query?

while(build this row from a query)
{
build a select statement and fill the options list
with dynamic data (a complete list, not just one at
a time like the parent while is doing).
<option>dynamic element</option>
<option>dynamic element</option>
<option>dynamic element</option>
<option>dynamic element</option>
Done
}

Thanks!
Don

Working sick stinks! dstefani (Don)

http://www.donstefani.com

 

[danielhozac]

Something like this maybe?

$result = mysql_query("SELECT * FROM sometable") or die("Couldn't query: " . mysql_error());
while ($row = mysql_fetch_assoc($result))
{
    $result2 = mysql_query("SELECT OptionsID, OptionsTitle FROM options WHERE SelectID='" . $row['ID'] . "'") or die("Couldn't query: " . mysql_error());
    echo &quot;<select name=\&quot;&quot; . $row['Name'] . &quot;\&quot;>&quot;;
    while ($row2 = mysql_fetch_assoc($result2))
    {
        echo &quot;<option value=\&quot;&quot; . $row2['OptionsID'] . &quot;\&quot;>&quot; . $row2['OptionsTitle'] . &quot;</option>&quot;;
    }
    echo &quot;</select><br />&quot;;
}

I hope this gets you started . //Daniel