That work great, thank you so much. I did post this in the wrong section, I didn't even notice *sorry*.
One last question, hopefully you can guide me in the right direction...
As I explained a link from page 1 brings up a form on page 2, now I was thinking I needed a page three to have this update page 2's contents to the database. If there's any easier way please tell me because this doesn't work >>
The following edit were made to page 2:
while(list($id, $name, $dis, $icon, $maker, $date) = mysql_fetch_array($result))
{
?>
<form method="post" id="edit" action="page3.php" class="style6">
<center>
<body bgcolor="Black" style="color: #008000">
<input type="hidden" name="id" value="<?=$_REQUEST['id'] ?>">
<strong class="font"><span class="style2">Name:</span></strong><span class="style4"><strong><br />
<input type="text" name="name" size="30" value="<?=$dis;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Icon:</span></strong><span class="style4"><strong><br>
<input type="text" name="icon" size="30" value="<?=$icon;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Maker:</span></strong><span class="style4"><strong><br />
<input type="text" name="maker" size="30" value="<?=$maker;?>"><br>
</strong></span>
<strong class="font"><span class="style2">Date:</span></strong><span class="style4"><strong><br />
<input type="text" name="date" size="30" value="<?=$date;?>"><br>
</strong></span>
<input type="submit" value="Add A DJ" name="B3">
<?php
}
}
include 'inc/closedb.php';
?>
Page 3:
<html>
<center>
<body bgcolor="Black">
<meta http-equiv="refresh" content="3; URL/upload/page1.php">
<?
$host = "localhost";
$user = "xxxxxx";
$pass = "xxxxxx";
$db = "xxxxxx";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$name = $_POST['name'];
$dis = $_POST['dis'];
$icon = $_POST['icon'];
$maker = $_POST['maker'];
$date = $_POST['date'];
if($_POST['action'] == 'edit'){
UPDATE (id, name, dis, icon, maker, date) Values ('NULL', '".$name."', '".$dis."', '".$icon."', '".$maker."', '".$date."') INTO upload WHERE id =".$_POST['id'];
@mysql_query($sql);?>
echo "The DJ Database Is Being Updated. Please Wait 3 Seconds." ;
<? }?>