Ad:

PHP Discussion Thread
Unsolved
Views: 592

Feb 22nd, 2009

MySQL - Some Records Not Deleting

Expand Post »

Im trying to delete records. Most delete ok but some don't and Im completly lost as to why...

The information Im storing are just URLs.

Could it be to do with some irregular characters within these URLs?

Is there a recomended way to store a URL?

Please help me out. Its quite a major flaw in my script

I think it probably is the irregular characters.

Here are the records which wont delete

PHP Syntax (Toggle Plain Text)
http://www.theflickzone.com/showthread.php?p=24961#post24961
http://www.theflickzone.com/tags.php?tag=Google+Video
http://www.theflickzone.com/showthread.php?p=25067#post25067
http://www.theflickzone.com/member.php?find=lastposter&f=34
http://www.theflickzone.com/member.php?find=lastposter&f=31
http://www.theflickzone.com/showthread.php?p=24961#post24961
http://www.theflickzone.com/tags.php?tag=Google+Video
http://www.theflickzone.com/showthread.php?p=25067#post25067
http://www.theflickzone.com/member.php?find=lastposter&f=34
http://www.theflickzone.com/member.php?find=lastposter&f=31

Well there are just some. There are many more.

Thanks

Similar Threads

Deleting records from 2 tables based on checkbox in PHP
deleting of a record through php on mysql in PHP
Deleting multiple rows from mysql with checkbox in PHP
Mysql Query in PHP
please help with deleting records using checkboxes in PHP

!Unreal

Reputation Points: 11

Solved Threads: 2

Junior Poster

Offline

112 posts
since Dec 2007

Permalink

Feb 22nd, 2009

Re: MySQL - Some Records Not Deleting

What error is returned?
Add or die(mysql_error()); to the closing bracket of the query as so:

php Syntax (Toggle Plain Text)
mysql_query("....")or die(mysql_error());
mysql_query("....")or die(mysql_error());

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Feb 22nd, 2009

Re: MySQL - Some Records Not Deleting

There isn't one

EDIT: Just for a bit of context...

php Syntax (Toggle Plain Text)
<?php
include('includes/config.php');
$referer = $_SERVER['HTTP_REFERER'];
$addtolist = $_GET['add'];
mysql_query("DELETE FROM spider WHERE url='$addtolist'")or die(mysql_error());
header("Location: $referer");
mysql_close($con);
?>
<?php
include('includes/config.php');
$referer = $_SERVER['HTTP_REFERER'];
$addtolist = $_GET['add'];
mysql_query("DELETE FROM spider WHERE url='$addtolist'")or die(mysql_error());
header("Location: $referer");
mysql_close($con);
?>

Last edited by !Unreal; Feb 22nd, 2009 at 10:17 pm.

!Unreal

Reputation Points: 11

Solved Threads: 2

Junior Poster

Offline

112 posts
since Dec 2007

Permalink

Feb 22nd, 2009

Re: MySQL - Some Records Not Deleting

Have you tried echoing $addtolist to make sure that it contains the value expected?

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Feb 23rd, 2009

Re: MySQL - Some Records Not Deleting

Yeah. Im expecting to get these characters. I just need to know how to handle them.

!Unreal

Reputation Points: 11

Solved Threads: 2

Junior Poster

Offline

112 posts
since Dec 2007

Permalink

Feb 23rd, 2009

Re: MySQL - Some Records Not Deleting

I managed to work this one out.

You have to work with the URLs in an encoded form. Using rawurlencode and rawurldecode.

Thanks for your help though

!Unreal

Reputation Points: 11

Solved Threads: 2

Junior Poster

Offline

112 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Disallow Multiple of the Same Usernames

Next Thread in PHP Forum Timeline: storing the selected value of a drop-down list

DaniWeb Message

Cancel Changes

User Name
Password