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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

e.g.
<?php
mysql_co nnect("localh ost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_ db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}
mysql_free_resul t($result );

Answered by Raksha , an ibibo Master, at 9:31 AM on June 18, 2008

array mysql_fetch_array ( resource $result [, int $result_type ] )

Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.


Return Values

Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined. By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use the numeric index of the column or make an alias for the column. For aliased columns, you cannot access the contents with the original column name.

Answered by Sharad Singh , an ibibo Master, at 3:11 PM on May 27, 2008

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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

Answered by Anju Singh , an ibibo Master, at 5:20 PM on May 24, 2008

Hi,

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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

Answered by Ajay Pal , an ibibo Master, at 8:08 AM on May 24, 2008

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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

Answered by Arti singh , an ibibo Specialist, at 10:23 PM on May 23, 2008

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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

e.g.
<?php
mysql_co nnect("localh ost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_ db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}
mysql_free_resul t($result );

Answered by Shobhit , an ibibo Master, at 6:45 PM on May 23, 2008

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.

Syntex : mysql_fetch_array(data,array_t ype)

where

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

Answered by Ashish Yadav , an ibibo Wizard, at 5:34 PM on May 23, 2008

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/xxxxxx.com/xxx.php on line 34
[/quote]

so your $xxx variable is not a proper resource. which means that there is an error in mysql_query("SQL statement")

do
$xxx = mysql_query("SELECT * FROM forum") or die(mysql_error());
in your script.

this will force the script to fail if there is an issue with the mysql statement and produce the error generated by mysql.

Answered by ayisha , an ibibo Master, at 5:19 PM on May 23, 2008

Walk in for aptitude test in Mass communication and journalism courses, BSc(IT), BJMC, DJMC, MCAJ, MMC, And many more courses.

10% discount in tution fee for on the spot registration

Venue: RK Film And Media Academy, Karol Bagh Pusa Road, Behind Telephone Exchange 8A/8 WEA , New Delhi 110005

Date 25. 05. 08.

Time: 11am 5pm

For more information, please call us at 9312237583, 011-65394941, 42, 44, 45 or online registration
Please visit our website i.e www.rkfma.com

Answered by Navin , an ibibo Citizen, at 4:19 PM on May 23, 2008

hi blogger the mysql_fetch_array function returns an associative array, but it also returns FALSE if there are no more rows to return! Using a PHP While Loop we can use this information to our advantage.

If we place the statement "$row = mysql_fetch_array()" as our while loop's conditional statement we will accomplish two things:

1. We will get a new row of MySQL information that we can print out each time the while loop checks its conditional statement.
2. When there are no more rows the function will return FALSE causing the while loop to stop!

mysql_fetch_array is actually a PHP function that allows you to access data stored in the result returned from a successful mysql_query. If you have been jumping around our MySQL Tutorial then you would have already seen this function popping up all over the place.
mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both
<?php
mysql_connect("lo calhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_ db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}

mysql_free_result($resu lt);
?>

Answered by laks , an ibibo Master, at 3:05 PM on May 23, 2008