richard_PHP Posted May 23, 2011 Share Posted May 23, 2011 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 More sharing options...
Maq Posted May 23, 2011 Share Posted May 23, 2011 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. Link to comment https://forums.phpfreaks.com/topic/237250-delete-from-does-but-doesnt-work/#findComment-1219185 Share on other sites More sharing options...
richard_PHP Posted May 23, 2011 Author Share Posted May 23, 2011 Soon as I read what you said I soon found what to do! It's the simple things.......... lol Link to comment https://forums.phpfreaks.com/topic/237250-delete-from-does-but-doesnt-work/#findComment-1219188 Share on other sites More sharing options...
Maq Posted May 23, 2011 Share Posted May 23, 2011 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 Link to comment https://forums.phpfreaks.com/topic/237250-delete-from-does-but-doesnt-work/#findComment-1219221 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.