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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate is for developers who want to document their knowledge of JavaScript and the HTML DOM.
The XML Certificate is for developers who want to document their knowledge of XML, XML DOM and XSLT.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
The PHP Certificate is for developers who want to document their knowledge of PHP and SQL (MySQL).
|
|
