drop down box

slimjim

What i am trying to do is, chose a letter template and have it load automatically into a text area without having to hit submit, so if ther are 5 choices and i chose one and it it highlighted, then automatically the btext that is echoed in the textarea the result show up. If anyone can help, I am staying online tonight to figure this out, i know this seems easy, but i guess not for me.

<?php
$letterresult = mysql_query("SELECT * FROM tletters");

echo "<p>Letter <select>\n";

if ($myrow = mysql_fetch_array($letterresult)) {

do {

printf("<option value=\"%s\">%s</option>\n", $myrow["id"], $myrow["lettername"]);

} while ($myrow = mysql_fetch_array($letterresult));
echo "</select></p>\n";
} else {

echo "Sorry, no records were found!"; 

}
?>
<textarea name="textmail1" cols="80" rows="5"><?echo $myrow["btext"];?></textarea>

Frederick

Add a short java snippet to your select tag. This snippet will initiate the selection you make when selected. Insure you place a "Choose" or "Select" in the first <option> so the drop menu will recognize the change.

<select name="name" size="1" onchange="this.form.submit();">
<option value="">Choose</option>
<?php // Query code ?>
</select>

slimjim

That won't work cause I need for it to show up in text area first before I submit, and in that code onchange, the form submits...
I want to submit manually, but I need what ever i chose from drop down box to populate in text area, or show up in text area, and then i can edit or what ever before i submit...

slimjim

Ok here is what I can not figure out how to do, if you can help me that would be great.
What I am trying to do is when i chose an item from dropdown box, which is poplulated
from databse colums in table. I want the textarea to be filled with the bhtml field from
the database according to what I have chosen from the dropdown so that I can edit
before i hit submit. Of course I am not sure if i have this coded right and surly
do not know javascript to use that. I have seen forms where if you check one thing,
that result will show up in field below that and so on, so i know there must be a way,
i just do not know how.

<select name="name" size="1" onChange="form.submit();"> 
<option value="">Choose</option> 
<?php 
$letterresult = mysql_query("SELECT * FROM tletters");

echo "<p>Letter\n";

if ($myrow = mysql_fetch_array($letterresult)) {

do {

printf("<option value=\"%s\">%s</option>\n", $myrow["id"], $myrow["lettername"]);

} while ($myrow = mysql_fetch_array($letterresult));
echo "</p>\n";
} else {

echo "Sorry, no records were found!"; 

}
?> 
</select> 
        <textarea name="htmlmail1" cols="80" rows="10"><br><? echo $myrow["bhtml"];?>
</textarea>

slimjim

ok is there a way to do this not using mysql but rather use txt files ? So i would chose item from drop down box and that info from that file would automatically load into the textarea so that i can edit it ? Any help would be great.

slimjim

If not possible using mysql. is there a way to load the data from a txt file into the textarea after chosing fom dropdown box so it can be edited before submitting.

slimjim

If not possible using mysql. is there a way to load the data from a txt file into the textarea after chosing fom dropdown box so it can be edited before submitting.

Aaxiler

I tried to work on the problem but my Javascript is limited as well. Look around for some basic tutorials with functions and such.

Aaxiler

I tried to work on the problem but my Javascript is limited as well. Look around for some basic tutorials with functions and such.

Aaxiler

I tried to work on the problem but my Javascript is limited as well. Look around for some basic tutorials with functions and such.

Aaxiler

I tried to work on the problem but my Javascript is limited as well. Look around for some basic tutorials with functions and such.

slimjim

Any ideas on how to what i want using txt files instead of data from database ?