skipskap Posted April 22, 2007 Share Posted April 22, 2007 Hello! I now have moved on to trying to search for and then delete via a form. There is 1 field, and a submit ("remove") button. When I run this I get back the an error message ('Error, insert query failed');. Again, any help with this would be greatly appreciated! <body> <?php if(isset($_POST['add'])) { // connect to database files include 'config.php'; include 'connect.php'; // add new user mysql_select_db($mysql); $query = "DELETE name, colour FROM pink WHERE name LIKE '%$delete%'"; mysql_query($query) or die('Error, insert query failed'); // close database include 'close.php'; echo "Record Deleted"; } else { ?> <form method="post"> <table width="500" border="2" cellspacing="0" cellpadding="0"> <tr> <td colspan="2">Please fill out the form below:</td> </tr> <tr> <td width="198">Name:</td> <td width="294"> <input name="delete" type="text" /> </td> </tr> <tr> <td>Submit:</td> <td> <input name="add" type="submit" id="add" value="Delete User"> </td> </tr> </table> </form> <?php } ?> </body> Thanks, Jordan Link to comment https://forums.phpfreaks.com/topic/48157-deleting-a-recordrow-from-a-database/ Share on other sites More sharing options...
AndyB Posted April 22, 2007 Share Posted April 22, 2007 DELETE from tablename WHERE something = whatever. I would caution against using LIKE with delete queries or you may find a whole load of records evaporating unintentionally. Link to comment https://forums.phpfreaks.com/topic/48157-deleting-a-recordrow-from-a-database/#findComment-235432 Share on other sites More sharing options...
skipskap Posted April 22, 2007 Author Share Posted April 22, 2007 Hey. Thanks a lot! That worked brilliantly! I have another question now! Do you have any idea of how to List All the contents of a database? Possibly tabulate them? Any ideas? Link to comment https://forums.phpfreaks.com/topic/48157-deleting-a-recordrow-from-a-database/#findComment-235440 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.