Writing data to a html textarea via php

[fredb]

I am trying to write data from my database to a html textarea. I can write the data with the php print function. Below is the code.

Any help you can offer is greatly appreciated.

Thanks,
Fred Bernstein

<?php
$sqlquery = "SELECT * FROM dbo.TBL_FACULTY_INFORMATION WHERE ID_NUM = $id_num";

$fi_tbl = odbc_exec($sqlconnect, $sqlquery);
if (!$fi_tbl) {
exit("Error in SQL 1");
}

odbc_fetch_row($fi_tbl);
$ln = odbc_result($fi_tbl,"Last_Name");
$fn = odbc_result($fi_tbl,"First_Name");
$mn = odbc_result($fi_tbl,"Middle_Name");
$notes = odbc_result($fi_tbl, "NOTES");

print "notes = $notes";
print "<p>fn = $fn</p>";
print "<p>ln = $ln</p>";

odbc_close($sqlconnect);
?>

<form id="form1" name="form1" method="post" action="">
<textarea name="textarea" cols="75" rows="8" id="<?php echo $notes ?>"></textarea>
</form>

[ak1dnar]

This is incorrect, you are trying to write in id attribute
[HTML]<textarea name="textarea" cols="75" rows="8" id="<?php echo $notes ?>"></textarea>[/HTML]

for most of the html form elements:
[HTML]<input type="text" name="element_name" value="<? echo $var_name; ?>" />[/HTML]

If you want to Print your PHP output variables in a HTML textarea, you can't use the ordianary way of other HTML form elements.

[HTML]<textarea name="textarea" cols="75" rows="8" id="id_goes_here"><?php echo $notes ?></textarea>[/HTML]

[ak1dnar]

Please note that I did not check your PHP Script to retrive Table values.
if there is Error in that please POST the errors here with your DB script.
;)

[fredb]

This is incorrect, you are trying to write in id attribute
[HTML]<textarea name="textarea" cols="75" rows="8" id="<?php echo $notes ?>"></textarea>[/HTML]

for most of the html form elements:
[HTML]<input type="text" name="element_name" value="<? echo $var_name; ?>" />[/HTML]

If you want to Print your PHP output variables in a HTML textarea, you can't use the ordianary way of other HTML form elements.

[HTML]<textarea name="textarea" cols="75" rows="8" id="id_goes_here"><?php echo $notes ?></textarea>[/HTML]

Your solution worked perfectly. Thank you very much for your help.

[rpjd]

Your solution worked perfectly. Thank you very much for your help.

I am trying to do more or less the same thing, I think. I have a html select option which calls an onclick() function. The javascript calls a file.php which in turn executes a database query retieving a value called $value. I am trying to then send the $value variable back to a text field within the HTML via javascipt. I have tried using several methods such this one, but haven't found anything that works as yet.
[code]
<input type="text" name="variable" value="<? echo $value ?>"/>
[code]
but all I get is a text field with php code. Is there a way of doing this?

RPJD :)

[TheMadMidget]

<input type="text" name="variable" value="<?php echo $value; ?>"/>