I’m not sure where the error in these scripts are. Edit.php seems to work fine.
The problem comes in at edit_form.php witch uses edit_data.php .
There is 1 table field i dont have listed and it stores IP addresses.
So can someone point out the error for me please.
edit.php
[code=php]
<html>
<body>
<table>
<tr>
<td align=”center”>EDIT DATA</td>
</tr>
<tr>
<td>
<table border=”1″>
<?
mysql_connect(“localhost”, “*****”, “******”) or die(mysql_error());
mysql_select_db(“*****”) or die(mysql_error());
$order = “SELECT id, eventname, host, time, date FROM event”;
$result = mysql_query($order);
echo (“<tr> <th>Event Name</th> <th>Host</th> <th>Time</th> <th>Date</th> <th>Edit</th></tr>”);
while ($row=mysql_fetch_array($result)){
echo (“<tr><td>$row[eventname]</td>”);
echo (“<td>$row[host]</td>”);
echo (“<td>$row[time]</td>”);
echo (“<td>$row[date]</td>”);
echo (“<td><a href=”edit_form.php?id=$row[id]”>Edit</a></td></tr>”);
}
?>
</table>
</td>
</tr>
</table>
</body>
</html>
edit_form.php
[code=php]
<html>
<head>
<title>Form Edit Data</title>
</head>
<body>
<table border=1>
<tr>
<td align=center>Form Edit Employees Data</td>
</tr>
<tr>
<td>
<table>
<?
mysql_connect(“localhost”, “******”, “******”) or die(mysql_error());
mysql_select_db(“******”) or die(mysql_error());
$order = “SELECT id, eventname, host, time, date FROM event
where id=’$id'”;
$result = mysql_query($order);
$row = mysql_fetch_array($result);
?>
<form method=”post” action=”edit_data.php”>
<input type=”hidden” name=”id” value=”<? echo “$row[id]”?>”>
<tr>
<td>Event Name</td>
<td>
<input type=”text” name=”eventname”
size=”24″ value=”<? echo “$row[eventname]”?>”>
</td>
</tr>
<tr>
<td>Host</td>
<td>
<input type=”text” name=”host” size=”24″
value=”<? echo “$row[host]”?>”>
</td>
</tr>
<tr>
<td>Time</td>
<td>
<input type=”text” name=”time” size=”24″
value=”<? echo “$row[time]”?>”>
</td>
</tr>
<tr>
<td>Date</td>
<td>
<input type=”text” name=”date” size=”24″
value=”<? echo “$row[date]”?>”>
</td>
</tr>
<tr>
<td align=”right”>
<input type=”submit”
name=”submit value” value=”Edit”>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
</body>
</html>
Edit_data.php
[code=php]
<?
mysql_connect(“localhost”, “*****”, “******”) or die(mysql_error());
mysql_select_db(“******”) or die(mysql_error());
$order = “UPDATE event
SET eventname=’$eventname’,
host=’$host’,
time=’$time’,
date=’$date’
WHERE
id=’$id'”;
mysql_query($order);
header(“location:edit.php”);
?>