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 Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.fyicenter.com')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
Remember that mysql_query() returns integer/FALSE on INSERT statements. If you run this script, you could get something like this:
SQL statement failed with error: 1142: INSERT command denied to user 'dev'@'localhost' for table 'fyi_links'
2007-05-10, 4665👍, 0💬
Popular Posts:
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...
Can you explain in GSC and VAF in function points? In GSC (General System Characteristic) there are ...
How comfortable are you with writing HTML documents entirely by hand? Everyone has a different prefe...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...