Collections:
PHP MSSQL - Deleting Existing Rows in a Table
PHP MSSQL - How To Delete Existing Rows in a Table?
✍: Guest
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 $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "DELETE FROM fyi_links WHERE id = 1102"; $res = mssql_query($sql,$con); if (!$res) { print("SQL statement failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { $number_of_rows = mssql_rows_affected($con); print("$number_of_rows rows deleted.\n"); } mssql_close($con); ?>
If you run this script, you will get something like this:
1 rows deleted.
If you run it again, no rows will be deleted. And you will get something like this:
0 rows deleted.
⇒ PHP MSSQL - Including Text Values in SQL Statements
⇐ PHP MSSQL - Updating Existing Rows in a Table
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-02-18, 1284🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...