Deleting a record php
Posted: Sun Oct 25, 2009 11:30 pm
Attempting to setup delete a record page. The below code I put together doesn't seem to work.
When the delete form is initiated, the old record data is visible including the $delid; however, once I click submit I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/claudett/public_html/membersarea/del_exlog.php on line 21
and the reult page I include a line to echo $delid and it returns $delid (no longer includes numeric value)
I know the obvious thing would be that my mysql query syntax is off, but I think the action I set up in the <form> tag may be what I am not executing well. Any thoughts?
Code: Select all
<?
$delid=$_GET['delid'];
echo $delid;
if(isset($_POST['submit'])){
$delquery="DELETE FROM table WHERE itemid = '$delid'";
$dresult=mysql_query($delquery);
if($picturepath1 != NULL){
unlink($picturepath);
}
}
?>
<form method="POST" action=invlog.php?delid=$delid >
TABLE AND FORM ELEMENTS...NOT MATERIAL SO I EXCLUDED
</form>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/claudett/public_html/membersarea/del_exlog.php on line 21
and the reult page I include a line to echo $delid and it returns $delid (no longer includes numeric value)
I know the obvious thing would be that my mysql query syntax is off, but I think the action I set up in the <form> tag may be what I am not executing well. Any thoughts?