PHP mysql_fetch_object() Function
Complete PHP MySQL Reference
Definition and Usage
The mysql_fetch_object() function returns a row from a recordset as an
object.
This function gets a row from the mysql_query() function and returns an
object on success, or FALSE on failure or
when there are no more
rows.
Syntax
| Parameter |
Description |
| data |
Required. Specifies which data pointer to use. The data
pointer is the result from the mysql_query() function |
Tips and Notes
Note: Each subsequent call to mysql_fetch_object() returns the next
row in the recordset.
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
while ($row = mysql_fetch_object($result))
{
echo $row->FirstName . "<br />";
}
mysql_close($con);
?>
|
The output of the code above could be:
Complete PHP MySQL Reference
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |

|
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |

|
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |

|
Promote collaboration among coworkers in your organization through project workspaces where others can efficiently find information and work together |

|
Personalize your company profile by bookmarking and organizing favorite content, uploading assets, posting photos, blogging, and more |

|
Interact with features like tagging, flagging, wikis and ratings found in the Web 2.0 Toolbox |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide. Request an
INSTANT DEMO or download a
FREE TRIAL today. |
|