DELETE FROM does, but doesn't, work

[richard_PHP]

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?

[Maq]

For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.

There's nothing to fetch when you're deleting.

[richard_PHP]

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

[Maq]

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