Displaying db fields in html pages

[rcja]

I've to display fields from a MySQL's db row in textboxes and let people to modify the content. I know how to connect and retrieve rows from db but I don't know how to put information retrieved inside a textbox .
Sure it should be simple but ...

Can anyone help me?

[Moonglobe]

$sql = "INSERT INTO blah SET blah1='".$_POST['textbox']."'.......";

[rcja]

This one seems to be the answer to the second part of the question. The first part is: how to put the retrieved data inside the textbox to display it.

Thank you in advance!

[LordShryku]

<input type="text" name="blah" value="<? echo $_POST['textbox']; // or whatever this variable should be ?>">

[onyx]

In mysql obtain the necessary data via the use of a select statement...something like:

select datafortextfield from table1 where ........

Using the information returned from this then you can place this in a textarea by

<textarea rows="20" cols="20"><?php print $valuereturned; ?></textarea>

or into a textfield as

<input type="text" size="20" value="<?php print $valuereturned; ?>"></input>