Simple editing text feature

Anon

Here's what I want to do, but have toyed around and been unable for it to do exactly what I want.

I want content on pages to be easily editable, in other words, you get a text area box (like I'm using now to type) that would have the current content with in it. Then the users can just change it, replace it, whatever; hit submit and the new content is replaced in the text file in which it was pulled from.

It seems as if it should be easy to me, but I've not found anything to get it work correctly (I can get the posting of the text into the correct HTML no problem). I'm a novice, so explaining word for word what to do would be greatly appreciated; thanks for the help!

Anon

Basically, this could be achieved using MySQL.

You set a mysql table with:
comlums:
pageid, content

and then you make you get your textarea from mysql call...

it would look like:
<?
//connect $db and define $page

if ($submit){
$query = "UPDATE table SET content = '$content' WHERE pageid = $pageid";
mysql_query($query,$db);
echo "Text updated";
} else {
$query = "SELECT content FROM table WHERE pageid = $page";
$result = mysql_query($query,$db);
$content = mysql_result($result, 0);
echo "<FORM METHOD='POST' ACTION='$PHP_SELF'>
<TEXTAREA name='content'>$content</TEXTAREA>
<INPUT TYPE='hidden' NAME='pageid' VALUE='$page'>
<INPUT TYPE='SUBMIT' NAME='submit' VALUE='Submit'></FROM>";
}
?>

Anon

That's more complicated than I can get, I don't have MySQL on this server, so I was thinking of using flat files - txt files. Here's what I've found and gathered, but it doesn't work (doesn't place the text in the text field for starters) and I'm not sure if it will update the text file that it is loading.

<title>Edit content</title>
<head>
</head>
<body>
<?
$real_path = realpath ("/home/wwwciva/public_html/text/");

if ($save) {
$fp = fopen("news.txt", "w");
fwrite($fp, $textfield);
fclose($fp);
}
?>
<form action="<?php echo $PHP_SELF ?>" method="post">
Edit Text here<br><textarea name="textfield" rows="10" cols="50" wrap="virtual">
<?php
echo $textfield;
?>
</textarea><br>
<input type="submit" name="save" value=":: submit">
</form>
<br><br><a href="post.php">See It.</a>
</body>

Maybe this will help? I've looked all over for correct coding but not sure what to use when, where, how, etc. Any help is appreciated!