Tools, FAQ, Tutorials:
Deleting Existing Rows in PHP
How To Delete Existing Rows in a Table in PHP?
✍: FYIcenter.com
If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row:
<?php include "mysql_connection.php"; $sql = "DELETE FROM fyi_links WHERE id = 1102"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows deleted.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows deleted.
⇐ Updating Existing Rows in PHP
2016-10-19, 1189👍, 0💬
Popular Posts:
What is EPUB 2.0 Metadata "dc:publisher" and "dc:rights" elements? EPUB 2.0 Metadata "dc:publisher" ...
How to detect errors occurred in the json_decode() call? You can use the following two functions to ...
Where to see some Examples of Invalid JSON Values? Here are some Examples of Invalid JSON Values: 1....
How to build a test service operation to dump everything from the "context.Request" object in the re...
Where to get a JSON.stringify() Example Code in JavaScript? Here is a good JSON.stringify() example ...