Deleting a record php

Posted on 16th Feb 2014 07:03 pm by admin

Attempting to setup delete a record page. The below code I put together doesn't seem to work.

| <?$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>

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?

Your Answer:

Login to answer

Other forums

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Rand() help needed
Hi all,

Can someone explain and give me a quick example of how I would go about this?

SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

License Issue - service type user
Hi,

I would like to understand the following issue regarding sap license.
I wish to

server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase