Ok if you go to [url]www.loddonexplorers.co.uk[/url] then click on contacts you see a list of contacts being called forom a database. There is also a field that is not displayed called ID. In the admin section of my site i can add enteries and that works fine but how would i go around deleting them? If possible could you tell me also how to edit them?
@bathurst_guyDec 23.2005 — #to delete and item the SQL is as follows [code=php]$query = mysql_query("DELETE FROM tablename WHERE id = $_POST[id]");[/code] and to edit [code=php]$query = mysql_query("UPDATE tablename SET columnname = $_POST[value], column2name = $_POST[value2] WHERE id = $_POST[id]");[/code] Now you will only want these queries to be called if the form has been submitted. Your better off placing all these on seperate pages to minimise confusion and code errors. So say delete.php have an if(isset($_POST[Submit])){ ...run query and then }else{ echo form.