help with dynamic population of textboxi

[twoseven]

PHP Code:

 $pulltemplate = mysql_query("SELECT id,name,content FROM templates");

<form action="list.php?do=edit" method="POST">
<select name="option">
<?PHP
while($row = mysql_fetch_array($pulltemplate,MYSQL_NUM)) {

echo "<option value=\"$row[1]\">$row[1]</option>\n";

}?>
</select>
<input type="Submit" name='$row[1]' Value="Edit" />
</form>

if($_REQUEST['do']=='edit'){

?>
<textarea rows="20" cols="50"><?php echo $pee; ?>  </textarea><?php
}?>

my question is how do i get the variable choosen $row[1] to pull the data when submit is clicked for the value located in the list
eg. if the list contains: a,b,c,d how would i pass the info in the variable to be able to edit the info.

[akanevsky]

I am sorry, but I do not completely understand what exactly do you want to pull, from where do you want to pull it, and where do you want to put it...

[twoseven]

PHP Code:

 $pulltemplate = mysql_query("SELECT id,name,content FROM templates"); 


thought that was where i was pulling it from but anyhow an even longer explanation.
i'm pulling from a database (outside of my vb one) now i'm trying to read the names of the templates and get the content area of the name of the template to the text area.
if a name is: xxx and it holds: "your stuff here"
i want it to put "your stuff here" in the textbox which is where the variable $pee is right now
may be my lack of english here (even though i'm from the US)

[akanevsky]

I would suggest you do the following:

Replace

PHP Code:

while($row = mysql_fetch_array($pulltemplate,MYSQL_NUM)) { 


with

PHP Code:

while ($row = mysql_fetch_array($pulltemplate,MYSQL_ASSOC)) { 


And then, if the original query is

PHP Code:

$pulltemplate = mysql_query("SELECT id,name,content FROM templates"); 


Then you can access the variables by:

PHP Code:

$row['id'], $row['name'], $row['content']