Sunday, August 17, 2008

PHP MySQL Delete From

Delete Data In a Database

The DELETE FROM statement is used to delete records from a database table.

Syntax
DELETE FROM table_name
WHERE column_name = some_value


Note: SQL statements are not case sensitive. DELETE FROM is the same as delete from.



To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.



Example


Earlier in the tutorial we created a table named "Person". Here is how it looks:



























FirstName

LastName Age
Peter

Griffin 35
Glenn Quagmire 33


The following example deletes all the records in the "Person" table where LastName='Griffin':



<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}


mysql_select_db("my_db", $con);

mysql_query("DELETE FROM Person WHERE LastName='Griffin'");


mysql_close($con);
?>


After the deletion, the table will look like this:



















FirstName LastName Age
Glenn

Quagmire 33

No comments: