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, 1304🔥, 0💬
Popular Posts:
How to use the XML to JSON Conversion Tool at freeformatter.com? If you want to try the XML to JSON ...
How To Get the Minimum or Maximum Value of an Array in PHP? If you want to get the minimum or maximu...
How to read Atom validation errors at w3.org? If your Atom feed has errors, the Atom validator at w3...
What is Azure API Management Publisher Dashboard? Azure API Management Publisher Dashboard is an Azu...
How to extend json.JSONEncoder class? I want to encode other Python data types to JSON. If you encod...