Here we define mysql_fetch_row()method with examples are given below-

The mysql_fetch_row() function returns a row from a recordset as 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_ row(d ata)

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_assoc() returns the next row in the recordset.

Example:

<?ph p
$c on = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$db_sele cted = mysql_select_db("test_db",$con );
$sql = "SELECT * from Person WHERE Lastname='Refsnes'";
$result = mysql_query($sql,$con);
print _r(mysql_fetch_row($result));

my sql_close($con);
?>

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

array mysql_fetch_row ( resource $result )

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


Return Values

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

mysql_fetch_row() fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

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

To get the value from the array we have to use array offset staring from 0. Each call to this mysql_fetch_row function returns the next record. Here one record is returned at a time and returns false if there is no more record to return. So we can easily use this function inside a while loop and display all the records. Each time at the starting of the while loop the mysql_fetch_row() function is checked and if true then the loop is executed and the records are displayed.

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

Well,

The mysql_fetch_row() function returns a row from a recordset as 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.

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

Example : Fetching one row with mysql_fetch_row()

<?php
$r esult = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);

e cho $row[0]; // 42
echo $row[1]; // the email value
?>

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

hello blog The mysql_fetch_row() function returns a row from a recordset as a numeric array.

To get the value from the array we have to use array offset staring from 0. Each call to this mysql_fetch_row function returns the next record. Here one record is returned at a time and returns false if there is no more record to return. So we can easily use this function inside a while loop and display all the records. Each time at the starting of the while loop the mysql_fetch_row() function is checked and if true then the loop is executed and the records are displayed. Here is one example and we have used our student table for this.

<?
$query=mysql_quer y("select * from student");
echo mysql_error();
echo "<b>id,name,class,mark</b><br> ";
while($nt=mysql_fetch_row( $query)){
echo "$nt[0],$nt[1],$nt[2],$nt[3] <br>";
}
?>

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

Here we define mysql_fetch_row()method with examples are given below-

The mysql_fetch_row() function returns a row from a recordset as 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_row(d ata)

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_assoc() returns the next row in the recordset.

Example:

<?php
$c on = 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_row($result));

my sql_close($con);
?>

Answered by Nagendra , an ibibo Master, at 7:14 PM on May 23, 2008

The mysql_fetch_row() function returns a row from a recordset as 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.

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

Example : Fetching one row with mysql_fetch_row()

<?php
$r esult = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);

e cho $row[0]; // 42
echo $row[1]; // the email value
?>

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

hi blogger
The mysql_fetch_row() function returns a row from a recordset as 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.

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

Example : Fetching one row with mysql_fetch_row()

<?php
$r esult = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);

e cho $row[0]; // 42
echo $row[1]; // the email value
?>

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

The mysql_fetch_row() function returns a row from a recordset as 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.

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

Example : Fetching one row with mysql_fetch_row()

<?php
$r esult = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);

e cho $row[0]; // 42
echo $row[1]; // the email value
?>

Answered by Ashish Yadav , an ibibo Wizard, at 2:44 PM on May 23, 2008

hello blog The mysql_fetch_row() function returns a row from a recordset as a numeric array.

To get the value from the array we have to use array offset staring from 0. Each call to this mysql_fetch_row function returns the next record. Here one record is returned at a time and returns false if there is no more record to return. So we can easily use this function inside a while loop and display all the records. Each time at the starting of the while loop the mysql_fetch_row() function is checked and if true then the loop is executed and the records are displayed. Here is one example and we have used our student table for this.

<?
$query=mysql_quer y("select * from student");
echo mysql_error();
echo "<b>id,name,class,mark</b><br> ";
while($nt=mysql_fetch_row( $query)){
echo "$nt[0],$nt[1],$nt[2],$nt[3] <br>";
}
?>

Answered by raj u , an ibibo Master, at 12:27 PM on May 23, 2008