Sorry this code is so long. But I am new to php and I need help. I did a ton of searches but I couldnt figure it out. Here is the code:
Edit Programs
<?php
echo "<form method=\"post\" action=\"$PHP_SELF\">";
echo "Enter Program ID Number to edit";
echo "<input type=\"text\" name=\"programID\">";
echo "<br><input type=\"submit\" name=\"submit\">";
echo "</form>";
if($submit)
{
mysql_connect("host", "user", "password");
mysql_select_db("database");
$result=mysql_query("SELECT * FROM programs WHERE programID='$programID'");
if($row=mysql_fetch_array($result))
{
echo "<form METHOD=\"POST\" ACTION=\"$PHP_SELF\">";
echo $row["programID"];
echo "<br>";
echo "<table WIDTH=\"600\" BORDER=\"0\" BGCOLOR=\"#FFFFFF\" CELLPADDING=\"2\" CELLSPACING=\"0\">";
echo "<tr>";
echo "<td WIDTH=\"100\">Date:</td>";
echo "<td WIDTH=\"500\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"date\" value=\"";
echo $row["date"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Name:</td>";
echo "<td WIDTH=\"500\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"name\" value=\"";
echo $row["name"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Version:</td>";
echo "<td WIDTH=\"500\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"version\" value=\"";
echo $row["version"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Vender:</td>";
echo "<td WIDTH=\"500\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"vender\" value=\"";
echo $row["vender"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Venders Page:</td>";
echo "<td WIDTH=\"500\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"vendersPage\" value=\"";
echo $row["vendersPage"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Download:</td>";
echo "<td WIDTH=\"100\"><input TYPE=\"TEXT\" SIZE=\"30\" NAME=\"download\" value=\"";
echo $row["download"];
echo "\"></td>";
echo "</tr>";
echo "<tr>";
echo "<td WIDTH=\"100\">Category:</td>";
echo "<td WIDTH=\"500\"><select NAME=\"category\"><option SELECTED>";
echo $row["category"];
echo "<option>AUDIO<option>BACKUP<option>DATABASE<option>DEVELOPMENT<option>EDITORS
<option>EMULATORS<option>IRC<option>MAIL<option>MPEG<option>MULTIMEDIA<option>
NETWORK<option>OS<option>UTILITIES<option>WEB/HTML</select></td>
</tr>
<tr>
<td WIDTH=\"100\">Description:</td>";
echo "<td WIDTH=\"500\"><textarea NAME=\"description\" COLS=\"40\" ROWS=\"5\">";
echo $row["description"];
echo "</textarea></td>";
echo "</tr>";
echo "</table>";
echo "<input TYPE=\"SUBMIT\" NAME=\"update\" VALUE=\"Update\">";
echo "</form>";
}
}
if($update)
{
mysql_connect("host", "user", "password");
mysql_select_db("database");
mysql_query("UPDATE programs SET date='$date', name='$name', version='$version', vender='$vender', vendersPage='$vendersPage', download='$download', category='$category', description='$description' WHERE programID=$programID");
}
?>
