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

using explode() to fill in checkboxes
Hi

I have a field stored in a table that contains regions in the UK separated by commas. Ther

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

Reg Ex
Im trying to search for the string: srv_9 (Dead ???)

I thought to use preg_match, however I d

SAP Business Suite
Hi all:

Within the SAP Business Suite solution I would like to ask you the main differenc

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.

We made a reverse goods movemen