Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Update Existing Rows in a Table
How To Update Existing Rows in a Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
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 include "mysql_connection.php"; $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8" . " WHERE id = 102"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows updated.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows updated.
2007-05-11, 5600👍, 0💬
Popular Posts:
Can you tell me how to check whether a linked list is circular? Create two pointers, and set both to...
What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...
How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqu...
How to measure functional software requirement specification (SRS) documents? Well, we need to defin...
What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...