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 Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.