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, 7662👍, 0💬
Popular Posts:
How do we configure “WebGarden”? “Web garden” can be configured by using process model settings in...
Do events have return type ? No, events do not have return type.
What are the types of variables x, y, y and u defined in the following code? #define Atype int* type...
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions To...
What is the difference between "calloc(...)" and "malloc(...)"? 1. calloc(...) allocates a block of ...