Thread: what is the use of mysql_fetch_array?

what is the use of mysql_fetch_array?

mysql_fetch_array is a PHP function to retrieve row of data as an array from mysql database.
Example

PHP Code:

$query="SELECT* FROM user WHERE id=5";
$result = mysql_query($query);
$row = @mysql_fetch_array($result, MYSQL_ASSOC);
//$row is an associative array holding user data where user id = 5 


mysql_fetch_array is mysql query .it is used to fetch the record from tha database. with help of this query you may run the data...

Example mysql_fetch_array() with MYSQL_NUM

<?php
mysql_connect("localhost", "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($result);
?>

mysql_fetch_array is a PHP function to retrieve row of data as an array from mysql database.

it retrieve rows one by one from the result set.......