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:
mysql_fetch_object() and mysql_fetch_array() Functions
What is the difference between mysql_fetch_object() and mysql_fetch_array() functions in PHP?
✍: FYIcenter
mysql_fetch_object() fetches the current row of data from the query result associated with the specified result identifier. The row is returned as an object. See the example code:
<?php $result = mysql_query("select * from fyiUser"); while ($row = mysql_fetch_object($result)) { echo $row->user_id; echo $row->fullname; } mysql_free_result($result); ?>
mysql_fetch_array() fetches the current row of data from the query result associated with the specified result identifier. The row is returned as an array with 3 options: an associative array, a numeric array, or both. The default behavior of mysql_fetch_array() is to return the row as an associative array and a numeric array. See the example code:
<?php $result = mysql_query("select * from fyiUser"); while ($row = mysql_fetch_array($result)) { printf ("ID: %s Name: %s", $row[0], $row["name"]); } mysql_free_result($result); ?>
2007-02-27, 7211👍, 0💬
Popular Posts:
How To Create an Add-to-Netvibes Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...
How do you estimate maintenance project and change requests?
How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...
How To Add Column Headers to a Table? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells I...
Is There Any XSD File to Validate Atom Feed Files? - RSS FAQs - Atom Feed Introduction and File Gene...