Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : mSQL Functions : msql_fetch_array

msql_fetch_array

Fetch row as array (PHP 4, PHP 5)
array msql_fetch_array ( resource result [, int result_type] )

msql_fetch_array() is an extended version of msql_fetch_row(). In addition to storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names as keys.

An important thing to note is that using msql_fetch_array() is NOT significantly slower than using msql_fetch_row(), while it provides a significant added value.

Parameters

result

The result resource that is being evaluated. This result comes from a call to msql_query().

result_type

A constant that can take the following values: MSQL_ASSOC, MSQL_NUM, and MSQL_BOTH with MSQL_BOTH being the default.

Return Values

Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

Examples

Example 1381. msql_fetch_array() example

<?php
$con
= msql_connect();
if (!
$con) {
   die(
'Server connection problem: ' . msql_error());
}

if (!
msql_select_db('test', $con)) {
   die(
'Database connection problem: ' . msql_error());
}

$result = msql_query('SELECT id, name FROM people', $con);
if (!
$result) {
   die(
'Query execution problem: ' . msql_error());
}

while (
$row = msql_fetch_array($result, MSQL_ASSOC)) {
   echo
$row['id'] . ': ' . $row['name'] . "\n";
}

msql_free_result($result);
?>


ChangeLog

Version Description
4.3.11 and 5.0.4 A bug was fixed when retrieving data from columns containing NULL values. Such columns were not placed into the resulting array.

Change Language


Follow Navioo On Twitter
msql_affected_rows
msql_close
msql_connect
msql_create_db
msql_createdb
msql_data_seek
msql_db_query
msql_dbname
msql_drop_db
msql_error
msql_fetch_array
msql_fetch_field
msql_fetch_object
msql_fetch_row
msql_field_flags
msql_field_len
msql_field_name
msql_field_seek
msql_field_table
msql_field_type
msql_fieldflags
msql_fieldlen
msql_fieldname
msql_fieldtable
msql_fieldtype
msql_free_result
msql_list_dbs
msql_list_fields
msql_list_tables
msql_num_fields
msql_num_rows
msql_numfields
msql_numrows
msql_pconnect
msql_query
msql_regcase
msql_result
msql_select_db
msql_tablename
msql
eXTReMe Tracker