Jump to content

DELETE FROM does, but doesn't, work


richard_PHP

Recommended Posts

I have some code which deletes a record from my database (which has been selected from the previous page). Only problem is, it comes up with error code, but still deletes from the database?

 

Error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/110mb.com/t/h/e/b/l/a/c/k/theblackwatch/htdocs/150749deleted.php on line 28

 

Code:

<?php
				$id = $_GET[id];
				// Start the connection to the database
				$conn = mysql_pconnect("***", "***", "***");
				// Select the database to use
				mysql_select_db("***", $conn);
				// Create the MySQL command to retrieve all records
				$sql = "DELETE FROM **** WHERE id ='$id'";
				$result = mysql_query($sql, $conn);
				$array = mysql_fetch_array($result);
				// Echo each entry as the value of the text boxes. This brings in the current info in the database
				echo "<p>Entry has been deleted.</p>";
			?>

 

Any way round it?

Link to comment
https://forums.phpfreaks.com/topic/237250-delete-from-does-but-doesnt-work/
Share on other sites

Soon as I read what you said I soon found what to do! It's the simple things.......... :( lol

Good.  Some side notes:

- Protect against sql injections by using mysql_real_escape_string on $id.

- Properly handle exceptions, in this case, for mysql.  Check out this tutorial - http://www.phpfreaks.com/blog/or-die-must-die

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.