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, 1348🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...