Collections:
PHP MSSQL - Updating Existing Rows in a Table
PHP MSSQL - How To Update Existing Rows in a Table?
✍: Guest
Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8" . " WHERE id = 102"; $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 updated.\n"); } mssql_close($con); ?>
If you run this script, you will get something like this:
1 rows updated.
⇒ PHP MSSQL - Deleting Existing Rows in a Table
⇐ PHP MSSQL - mssql_fetch_array() - Looping through Returning Rows
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-02-18, 1374🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...