Hi,
Having a problem with a nested loop outputting to html.
Trying to dynamically write out three textboxes onto the page, and populate them with the resultset of a simple query.
This is the query:

$sql = mysql_query("Select write_region From resume_locations Where resume_id = '$res_id'");

The three textboxes are then written out via the following:
for($n=0;$n<3;$n++) {
echo "<input type=\"text\" name=\"wlocation[]\" size=\"28\" maxlength=\"185\" style=\"font-size: 10px\"\n";

I then tried to use another loop to populate the textbox values with the results of the query. Please note, there should always be three textboxes, even if the query returns zero rows. That way the user can enter data into the textboxes.
So the next loop is:

while($wl = mysql_fetch_array($sql)){
echo "value=\"" .$wl[write_region]."\"\n";
}

Then close the textbox:

echo " /><br />\n";
}

Of course what's happening is that only the first row of data from the query is being written out, the other textboxes are empty, although in this particular query there should be 2 rows of data.

Any help would be gratefully appreciated.
Thanks!

What that will give you is

<input type="text" name="wlocation[]" size="28" maxlength="185" style="font-size:10px"
value="row1" value="row2" value="row3" /><br />

Instead, put the while loop around everything:

PHP Code:

while($wl = mysql_fetch_array($sql)){
echo "<input type=\"text\" name=\"wlocation[]\" size=\"28\" maxlength=\"185\" style=\"font-size: 10px\"\n";
 echo "value=\"" .$wl[write_region]."\"\n";
 echo " /><br />\n";
} 


That will give you 3 text boxes, with row1 in the first, row2 in the second etc.

Hi,
Thanks! That works nicely...the only catch is that I need to have it write out 3 textboxes total, regardless of how many records are returned by the query, even if there are no records returned.
Is there any easy way to do that, perhaps with an outside loop that counts up to three?

Thanks.

How about ::

PHP Code:

for($n=0; $n<3; $n++) {
  echo "<input type=\"text\" name=\"wlocation[]\" size=\"28\" maxlength=\"185\" style=\"font-size: 10px\"\n";
  if($wl = mysql_fetch_array($sql)){
    echo "value=\"" .$wl[write_region]."\"\n";
  }
  echo " /><br />\n";
} 


This is almost exactly what you had in the first place, but with a simple if() instead of a while in the middle. That way it picks off one result each time if there is one available rather than doing them all the first time around.

Thanks for the help! That worked well!