I am trying to use the sql delete from statement to delete certain data (which are urls) from my db, but they don't seem to actually get deleted. (there are no errors, of course, so it looks like the code is working, but the data does not actually get erased)'
I was curious if this is because I'm using an actual URL (http://www.whatever.com) to locate the data within the sql database.... would passing on certain characters cause problems? (like say a url with "http://www.whatever.com/?file=something" etc?
Basically, my code looks like this:
$del = mysql_query("DELETE FROM items WHERE url = '$delurl'");
and $delurl is an actual URL link that is found earlier in the script.
Is there a problem with the way this passes to the database because of the way some urls are? (having question marks, etc. in them?) Is there some code I should use to strip the special characters out of the urls? Hopefully this makes sense! :)