Code: Select all
<html>
<head>
<script src="selectitle.js"></script>
</head>
<?php
// Connects to your Database
$link = mysql_connect("?", "?", "?") or die(mysql_error());
mysql_select_db("?",$link) or die(mysql_error());
if (!mysql_select_db("?", $link)) {
echo 'Could not select database';
exit;
}
?>
<center><table><tr><td>Title:</td><td>
<?php
echo '<select onchange="showTitle(this.value)">';
$data = mysql_query("SELECT titlename FROM titles");
while($row = mysql_fetch_assoc($data)) {
echo '<option value="'.$row['titlename'].'">'.$row['titlename'].'</option>';
}
echo '</select>';
?></td></tr></table></center>
<?php
$q=$_GET["q"];
// Connects to your Database
$link = mysql_connect("?", "?", "?") or die(mysql_error());
mysql_select_db("?",$link) or die(mysql_error());
if (!mysql_select_db("?", $link)) {
echo 'Could not select database';
exit;
}
$sql="SELECT * FROM titles WHERE id = '".$q."'";
$result = mysql_query($sql);
?>
<center><table border=1 cellpadding=5 cellspacing=0 width=350>
<font color="#CC0000"><h2><center>Edit a Title</h2></center></font>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<tr><td>Title Name:</td><td>
<input type="text" name="titlename" maxlength="60" value=" <?php echo $row['titlename']; ?>">
</td></tr>
</html>