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

file_put_contents and createimagefromjpeg
All,
I do somethings and then I have the following code:
file_put_contents('./test/'.$filename

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Help with ORDER BY
Hello. I would like to order by ascending States, then Cities, then Gyms in the following code, but

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

Checking BOM Authorization Group
Hai Friends,

I have developed a mulitilevel BOM display report. End users have been assig

C problem struct and string
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<