Re: won't delete

Most likely, you need to enclose $id in single quotes so that mysql recognizes it as a character string. $sql = "DELETE FROM emails WHERE id='$id'" Less likely, you don't have delete privileges. Doug --Original Message Text--- From: Cameron Showalter Date: Tue, 8 Apr 2003 09:10:38 -0700 Hello, With the following script, I am able to enter data, but I cannot modify or delete data, no errors, it just does nothing. obviously I'm missing something, but I don't know what. thanks in advance. Cameron "; } elseif ($delete) { $sql = "DELETE FROM emails WHERE id=$id"; $result = mysql_query($sql); echo "$sql Record deleted! "; } else { if (!$id) { $result = mysql_query("SELECT * FROM emails",$db); while ($myrow = mysql_fetch_array($result)) { printf("%s %s \n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]); printf("(DELETE) ", $PHP_SELF, $myrow["id"]); } } ?> ">ADD A RECORD "> "> First name:"> Last name:"> email:"> store:"> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php