drewb29693

I am runnig the fetch array and everything is working great. What i am having trouble with is when i go to update a row on another page, it is only grabbing the last $POST_['goal_id'] because i don't know how to store ever one that passes through that while loop. if i could just assign each post that it runs through in the the loop to a variable that would be great, but i am new at this so i don't know how. Any help would be great. <?php $line = 1; while($row1 = mysql_fetch_array($result)){ ?> <tr> <td width="124" height="40" align="right" valign="top" scope="col"><?php echo "Goal ". $line++ . ":";?><span class="style1">__</span> </td> <td width="408" height="40" valign="top" scope="col"><?php echo $row1['goal']; ?></td> <input type="hidden" readonly="readonly" name="goal_id" id="goal_id" value="<?php echo $row1['goal_id'];?>" size="12"/> <?php } ?>

This page updates values already in a particular database. I can get the values to show in the dropdown menu and i can get the page to update my database. I need to know how to set the default value on the dropdown to what the customer has already entered instead if just want is first in the table. It is probably something easy i just can't think of it. Thanks in advance whoever fixes my problem. Here is my code: <td height="40" align="right" valign="top" bgcolor="#FFFFFF">Time Type:<span class="style1">__</span></td> <td align="left" valign="top"><label> <?php $result = mysql_query("SELECT type, visit_id FROM visit_type "); ?> <select name="visit" id="visit"> <?php while($row = mysql_fetch_array($result)) { ?> <?php echo '<option value=' . $row[visit_id] . '> ' . $row['type'] . '</option> '; ?> <?php } ?> </select> </label></td>