Delete data from a mysql database

15 Apr

/*
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.”;

?>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: