Looking for somewhere to host your site? Browse our PHP web hosts section!

Home > Code Snippets > Delete data from a MySQL database

Delete data from a MySQL database

Description

How to remove and erase stored information from a MySQL database table.

The code


<?php


/*
 * Change the first line to whatever
 * you use to connect to the database.
 *
 * Change tablename to the name of your 
 * database table.
 *
 * This example would delete a row from
 * a table based on the id of the row.
 * You can change this to whatever you
 * want.
 */

// Your database connection code
db_connect();

$query "DELETE FROM tablename WHERE id = ('$id')";

$result mysql_query($query);

echo 
"The data has been deleted.";

?>

Get the code

Download the file to your computer: Click here to get the file