PHP mysql_fetch_array() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_fetch_array() function returns a row from a recordset as an associative array
and/or a numeric array.
This function gets a row from the mysql_query() function and returns an array on success, or FALSE on failure or
when there are no more
rows.
Syntax
mysql_fetch_array(data,array_type)
|
| Parameter |
Description |
| data |
Required. Specifies which data pointer to use. The data
pointer is the result from the mysql_query() function |
| array_type |
Optional. Specifies what kind of array to return. Possible values:
- MYSQL_ASSOC - Associative array
- MYSQL_NUM - Numeric array
- MYSQL_BOTH - Default. Both associative and numeric array
|
Tips and Notes
Note: After the data is retrieved, this function moves to the next row
in the recordset. Each subsequent call to mysql_fetch_array() returns the next
row in the recordset.
Tip: Field names returned by this function are case-sensitive.
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 WHERE Lastname='Refsnes'";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_array($result));
mysql_close($con);
?>
|
The output of the code above could be:
Array
(
[0] => Refsnes
[LastName] => Refsnes
[1] => Kai Jim
[FirstName] => Kai Jim
[2] => Taugata 2
[Address] => Taugata 2
[3] => 22
[Age] => 22
)
|
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 |
|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
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.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|
HOME
Printer friendly page
