Hi,

I have a table called "micromouse" within that table I have a load of
variables with HTML code in it. I would like an "editing" page that has a
drop down box of all the variables in that loads the contents of the vaiable
into a text box, which I can edit and click on "Update". The names of the
variables are given in the option value.

The code I have so far is this:

Code:
<html>
<head>
<title>mySQL Editing Page</title>
</head>
<body>
<p><b><font size="5" face="Arial">Website Editing Page</font></b></p>
<form method="GET" name="micromouse" action=<?php echo
$_SERVER['PHP_SELF']?>
<p>
<font size="2" face="Arial">Select page to edit: </font><font
face="Arial">
<select size="1" name="page_to_edit"
onchange="document.micromouse.submit();">
<option value="welcome">Welcome</option>
<option>============</option>
<option value="whatismicromouse">What Is Micromouse?</option>
<option value="thetask">The Task</option>
<option value="umldesign">UML Design</option>
<option value="chassis">Chassis</option>
<option value="hardware">Hardware</option>
<option value="sensors">Sensors</option>
<option value="software">Software</option>
<option value="testing">Testing</option>
<option value="documentation">Documentation</option>
<option value="presentation">Presentation</option>
<option value="gantchart">Gant Chart</option>
<option value="downloads">Downloads</option>
<option>============</option>
<option value="teammembers">Team Members</option>
<option value="thelab">The Lab</option>
<option value="thewebsite">The Website</option>
<option value="contactteam">Contact The Team</option>
</select></font><br>
<br>
<textarea rows="22" name="text_edit" cols="94"></textarea></p>
</form>
<p>&nbsp;</p>
</body>
</html>
Is anyone able to add the PHP/mySQL code to allow me to do what I want!

Thanks in advance!