I need help insert data to input box

[inbowns]

I just recently wrote a program for me employer it's a smooth running program although I don't have any way to modify or delete a record when I need to.

I was thinking that I want to change the data that comes out as my results and have it display in an inputbox rather than plain text that I cannot edit, from there i would be able to edit the data and resubmit it back into my database.

My only problem is I don't know how to do this. If this sounds too strange for you or you need the code to see what I'm talking about please write me and I'll send it to you.

Any help would be greatly appreciated
Thank you.

[barand]

If this is too basic I apologise as I'm not sure which bits you don't know.

First you need to query the database for the record you want to change

eg. $query=mysql_query("SELECT phoneno from employee where empid-'$id' ");
$row=mysql_fetch__array($query)

then display the results in a form (storing the id in a hidden field so it too gets sent

<form action="update.php" method="post">
<input type="hidden" name="id" value="$id">
<input type="text" name="phone" value="<?=$row["phoneno"]?>">
<input type="submit" value="Update">
</form>

In the update.php you can pick up the editted phone number and id with
$phoneno = $POST["phone"];
$id = $POST["id"];

All you need now is an update query
mysql_query("UPDATE employee SET phoneno='$phoneno' WHERE empid='$id'"

Having done the update you might then want to redirect to another page with

header("location: another.php");

hth