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, 1268🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...