At the moment this code accepts changes and deletes from the Db but when the
submit button is pressed it echos------------- 'Record updated/edited' and i
have to go back and refresh to view the updated list, how can i just have it
refresh. When you open the file it shows the list but when editing it
disappears.
<html>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
if ($submit) {
// here if no ID then adding else we're editing
if ($id) {
$sql = "UPDATE employees SET first='$first',last='$last' WHERE id=$id";
} else {
$sql = "INSERT INTO employees (first,last) VALUES ('$first','$last')";
}
// run SQL against the DB
$result = mysql_query($sql);
echo "Record updated/edited!<p>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM employees WHERE id=$id";
$result = mysql_query($sql);
echo "$sql Record deleted!<p>";
} else {
// this part happens if we don't press submit
if (!$id) {
// print the list if there is not editing
$result = mysql_query("SELECT * FROM employees",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<ahref=\"%s?id=%s\">%s- V - %s......</a>\n", $PHP_SELF,
$myrow["id"], $myrow["first"],$myrow["last"]);
printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF,
$myrow["id"]);
}
}
?>
<P>
<br>
<P>
<form method="post" action="<?php echo $PHP_self?>">
<?php
if ($id) {
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
Team A:<input type="Text" name="first" value="<?php echo $first?>">
<br><br>
Team B:<input type="Text" name="last" value="<?php echo $last ?>"><br><br>
<input type="Submit" name="submit" value="Enter Team Names">
</form>
<?php
}
?>
</body>
</html>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
