PHP MySQL Delete
In some situation you need to delete the records from MySQL database. For example if a staff permanently quit the company or your company wants to removes some resellers etc., in such situation you can use The DELETE statement which quickly erases records from a MySQL table.
DELETE * FROM tableName WHERE ID = SomeID
PHP & MySQL Example Code
mysql_query("DELETE FROM Employees WHERE Name='Joy'");
Note: If you want to perform a large scale delete then It will be a wise choice to take a backup of Database before performing query.
It's only fair to share...
Posts you may like:
Delete records within a specific Range from MySQL table
If you want to delete a range of records from MySQL table then you can …
php pagination code example using MySql database
Here is a working code for pagination using PHP and MySql database. Its is tested …
How to include php headers on html site
PHP is a powerful language for web development, it have many in built functions. Here …
Meta refresh tag HTTP-EQUIV “REFRESH”
The refreshing time of a webpage can be define by using html tag HTTP-EQUIV “REFRESH”. …
Open link in a new window
Here is some ways to make html links for a webpage, it will be useful …