The following problem:

I started last night with PHP Scripting, thanks to Mr. Yank I was able to get a pretty quick grasp on the logic associations of interaction between PHP and MySQL.
Now I created a very simple example of a DB driven page (some of you will crack up)...you can see it http://www.cte-networks.com/test.php . So I was able to put in the admin section the ability to input text onto the "test.php"...no problem with that. But how can I modify the Admin section so when I enter the section, I see in the Text Boxes the already existing Text and I can delete, edit or add text to the database...sorry I know it is probably the easiest thing to do, but don't forget I am only 1 day old in PHP and MySQL. Here is the Code I am currently using in the Admin Section:

<html>
<head>
<title>Admin Section</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST>
<P><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Type your Text
for the left column hereBR>
<TEXTAREA NAME="textleft" ROWS=10 COLS=40 WRAP>
</TEXTAREA>
</font><BR>
<INPUT TYPE=SUBMIT NAME="submittext1" VALUE="SUBMIT">
</FORM>

<?php

// Connect to the database server
$dbcnx = @mysql_connect("localhost",
"root", "password");
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
}

// Select the test database
if (! @mysql_select_db("dbname") ) {
echo( "<P>Unable to locate the joke " .
"database at this time.</P>" );
exit();
}

// If a text has been submitted,
// add it to the database.
if ("SUBMIT" == $submittext1) {
$sql = "INSERT INTO test1 SET " .
"TextLeft='$textleft' ";
if (mysql_query($sql)) {
echo("<P>Your Text has been added.</P>");
} else {
echo("<P>Error adding submitted text: " .
mysql_error() . "</P>");
}
}

?>

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST>
<P><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Type your Text
for the right column hereBR>
<TEXTAREA NAME="textright" ROWS=10 COLS=40 WRAP>
</TEXTAREA>
</font><BR>
<INPUT TYPE=SUBMIT NAME="submittext2" VALUE="SUBMIT">
</FORM>

<?php

// Connect to the database server
$dbcnx = @mysql_connect("localhost",
"root", "password");
if (!$dbcnx) {
echo( "<P>Unable to connect to the " .
"database server at this time.</P>" );
exit();
}

// Select the test database
if (! @mysql_select_db("dbname") ) {
echo( "<P>Unable to locate the joke " .
"database at this time.</P>" );
exit();
}

// If a text has been submitted,
// add it to the database.
if ("SUBMIT" == $submittext2) {
$sql = "INSERT INTO test2 SET " .
"TextRight='$textright' ";
if (mysql_query($sql)) {
echo("<P>Your Text has been added.</P>");
} else {
echo("<P>Error adding submitted text: " .
mysql_error() . "</P>");
}
}

?>


<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="test.php">Go
back to Test Site</a></font></p>
</body>
</html>