Database / textarea

[kashmirekat]

How do I display the information from a database into a textarea in a form and then allow the modified information from that textarea to be resent to the db?

[jayant]

Use SELECT query to get information from database(D😎.

Get the the data into a variable using fetch_array() or similar function.

suppose you have the text in $res['desc_text']

then use

<textarea>
<?
echo $res['desc_text'];
?>
</textarea>

[kashmirekat]

I've tried this:

<?
$result = mysql_query("SELECT * FROM lp");
$myrow = mysql_query($result);
printf("<textarea rows=4 cols=20>%s</textarea>\n<br>", $myrow["lp"]);
?>

And I have no idea what is wrong. I have tried dozens of different combinations and other things, yet it just won't display the contents of what is in table lp and row lp. I named them the same for the purpose. 😕 Any help would be greatly appreciated.

And yes, I do have the db connection right! 😉

[jayant]

first give some condition in WHERE to retrieve only that row, which is required.

<?
$result = mysql_query("SELECT * FROM lp WHERE <some_condition>");
$myrow = mysql_query($result);
$myrow=mysql_fetch_array($myrow);
echo "<textarea rows=4 cols=20> $myrow['lp'] </textarea>\n<br>"; 

?>

[siwis]

You also need to name your textarea, alse when you write back to the db upon submission, the data will be lost and your submission will clear the contents of the database field:

<?PHP
$lp = $myrow["lp"];
?>
<textarea name="lp" rows="5" columns="30><?PHP echo $lp ?><textarea>
<?PHP
?>

[jayant]

Originally posted by siwis
You also need to name your textarea, alse when you write back to the db upon submission, the data will be lost and your submission will clear the contents of the database field:

:o , how did I forget that 🙁