$query works but i still get a returned error
| From: | PAUL FERRIE | Date: | Thu, 20 Nov 2003 12:28:48 +0000 |
| Subject: | $query works but i still get a returned error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-170403@lists.php.net to get a copy of this message | ||
I am not sure what the problem is here. The script runs and deletes the
relevent row but still returns "DATA from albums loaded
row id 658 did not get sent
Error deleting row!
Warning: Cannot modify header information - headers already sent by (output
started at /home/pferrie/public_html/vinrev/adm/deleteid.php:2) in
/home/pferrie/public_html/vinrev/adm/deleteid.php on line 21
"
<?
if (isset($_GET['tablename'])) {
echo "DATA from <b>{$_GET['tablename']}</b> loaded<br>";
} else {
echo "<i>$tablename</i> did not get sent<br>";
}
if (isset($_GET['id'])) {
echo "row id= <b>{$_GET['id']}</b><br>";
} else {
echo "row id <i>$id</i> did not get sent<br>";
}
include("connection.php");
$query = mysql_query("DELETE FROM $tablename WHERE id= $id")or die("<br>ther
was an error<br> tablename:= $tablename<br>
row id:= $id");
if(!mysql_query($query)) {
echo"Error deleting row!");
}
Header("Location: delete.php?success=$success");
?>
I am php newbie and might be missing the obviuos
Cheers Paul
example
http://thor.ancilenetworks.co.uk/~pferrie/vinrev/adm/myadmin.html
"Delete record"