displaying db field into text fields, deleting.... etc help

[k994519]

Hey guys,

can someone guide me how to put my database fields into a html text field allow changes to or delete the DBfield then save the changes to the database.

e.g

table

---

Module_id
Module_details

---

appreicate all help given.......

[mmilano]

<form method=post action=<?=$_SERVER[PHP_SELF]?>>
module id<input type=text name=module_id> <br>
details<input type=text name=module_details> <input type=submit name=submit>
</form>

<?
if($_POST)
{
  $result = mysql_query("insert into table (module_id,module_details) values('$module_id','$module_details')");
}
?>

that is how you would insert .. editing and deleting would be similar, except the sql query.

update table set module_details='$module_details' where module_id='$module_id'

delete from table where module_id='$module_id'

[k994519]

HI mmilano

I can display the fields but there is no datafrom the database inside the fields......

please help thanks