Nested While Loop Issue

Jako · 08-06-2008, 05:06 AM

I'm having trouble with nested while loops.

Here's what I am currently doing.

PHP Code:


			
// sql query

$sql = 'SELECT * FROM rank LEFT JOIN national on national.n_id = rank.rank_nation ORDER BY rank ASC';

$result = mysql_query($sql) or dies(mysql_error());



// get details of all nations

$sql_nation = "SELECT * FROM national ORDER BY national_name ASC";

$nation_list = mysql_query($sql_nation) or die (mysql_error());

any my tested loops look something like this.

PHP Code:


			
    <? while($row = mysql_fetch_assoc($result)) { ?>

    <tr>

        <td><? echo $row['rank']; ?></td>

        <td><input name="rank" type="text" value="<? echo $row['rank']; ?>" size="20" maxsize="100" /></td>

        <td><select name="national_id"><option selected value="<? echo $row['national_id']; ?>"><? echo $row['national_name']; ?></option>

<option>-------</option>

 <? 

 while($r = mysql_fetch_assoc($nation_list)) { ?><option value="<? echo $r['n_id']; ?>"><? echo $r['national_name']; ?></option>

<? } ?> </select></td>

        <td><input name="points" type="text" value="<? echo $row['rank_points']; ?>" size="20" maxsize="100" /></td>

    </tr>

    <? } ?>

How can I fix this? Right now the first loop is working alright, but the nested while loop only works once.