hi singh 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.
Syntax :---
mysql_fetch_row(data)
b ool make_record_from_result_set( MYSQL_RES *results, record *osi_record )
{
MYSQL_ROW row;

...


unsigned long *lengths;
if( ( results == NULL ) || ( osi_record == NULL ) )
{


return FALSE;
}
/* verify we have results. */
if( ( row = mysql_fetch_row( results ) ) == NULL )
{
return FALSE;
}

Example
<?php
$ con = 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));

mysql_close($con);
?>

Answered by: Saurabh at 8:23 AM on May 16, 2008 | Saurabh's Q&A | Report Abuse
Rate this : 00


Well,

Dear

Definitio n and Usage

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(data)
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
$con = 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));

mysql_close($con);
?>

Answered by laks , an ibibo Master, at 3:28 PM on May 21, 2008

well sharad
mysql_fetch_row() function returns a record by taking a result identifier. Here it returns the set of data as an 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.

Syntax

mysql_ fetch _row(data)

Answered by jaivir , an ibibo Master, at 7:21 AM on May 17, 2008

the mysql_fetch_row() function returns a row from a recordset as a numeric array.
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.
A MYSQL_ROW structure for the next row. NULL if there are no more rows to retrieve or if an error occurred.
mysql_fetch_row()

*

CR_SERVER_LOST

The connection to the server was lost during the query.
*

CR_UNKNOWN_ERROR

An unknown error occurred.

Example

MYSQL_ ROW row;
unsigned int num_fields;
unsigned int i;

num_fields = mysql_num_fields(result);
whi le ((row = mysql_fetch_row(result)))
{
unsigned long *lengths;
lengths = mysql_fetch_lengths(result);
for(i = 0; i < num_fields; i++)
{
printf("[%.*s] ", (int) lengths[i],
row[i] ? row[i] : "NULL");
}
printf("\n");
}

Answered by Om Prakash , an ibibo Master, at 1:46 PM on May 16, 2008

hi singh
mysql_fetch_row() function returns a record by taking a result identifier. Here it returns the set of data as an 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.

Syntax

mysql_ fetch _row(data)

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.

Answered by raj u , an ibibo Master, at 1:37 PM on May 16, 2008

Hi Sharad,

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(data)
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
$con = 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));

mysql_close($con);
?>

Answered by Reeta K , an ibibo Master, at 11:06 AM on May 16, 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.
Syntax :---
mysql_fetch_row(data)
b ool make_record_from_result_set( MYSQL_RES *results, record *osi_record )
{
MYSQL_ROW row;

...


unsigned long *lengths;
if( ( results == NULL ) || ( osi_record == NULL ) )
{


return FALSE;
}
/* verify we have results. */
if( ( row = mysql_fetch_row( results ) ) == NULL )
{
return FALSE;
}

Example
<?php
$ con = 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));

mysql_close($con);
?>

Answered by Saurabh , an ibibo Master, at 8:23 AM on May 16, 2008

Well,

Dear

Definition and Usage

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(data)
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
$con = 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));

mysql_close($con);
?>

Answered by Ajay Pal , an ibibo Master, at 6:43 AM on May 16, 2008

mysql_fetch_row() function returns a record by taking a result identifier. Here it returns the set of data as an 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.

Syntax

mysql_fetch _row(data)

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.

Answered by Nagendra , an ibibo Master, at 11:17 PM on May 15, 2008

well Sharad,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
?>

For more information , please do visit source site:

http://in.php.net/mys ql_fetch_ row
Hope it will help you out.

Answered by Uttam , an ibibo Master, at 9:13 PM on May 15, 2008

Hi sharad;
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(data)
b ool make_record_from_result_set( MYSQL_RES *results, record *osi_record )
{
MYSQL_ROW row;

...


unsigned long *lengths;
if( ( results == NULL ) || ( osi_record == NULL ) )
{


return FALSE;
}
/* verify we have results. */
if( ( row = mysql_fetch_row( results ) ) == NULL )
{
return FALSE;
}

...


/* verify we have the known number of fields. */
if( mysql_num_fields( results ) != 9 )
{
return FALSE;
}
/* create the record structure here. */
if( row[1] != NULL )
{
safe_strlcpy( osi_record->file_path, row[1],
sizeof( osi_record->file_path ) );
}
if( row[2] != NULL )
{
safe_strlcpy( osi_record->hash_algorithm, row[2],
sizeof( osi_record->hash_algorithm ) );
}
if( row[3] != NULL )
{
safe_strlcpy( osi_record->hash, row[3], sizeof( osi_record->hash ) );
}
if( row[4] != NULL )
{
safe_strlcpy( osi_record->filter_description , row[4],
sizeof( osi_record->filter_description ) );
}
if( row[5] != NULL )
{
safe_strlcpy( osi_record->block_name, row[5],
sizeof( osi_record->block_name ) );
}
if( row[8] != NULL )
{
lengths = mysql_fetch_lengths( results );
if( lengths != NULL && lengths[8] > 0 )
{
memcpy( &(osi_record->stats), row[8], lengths[8] );
unwrap_record( osi_record );
}
}
if( row[6] != NULL )
{
osi_record->reason = atol( row[6] );
}
if( row[7] != NULL )
{
osi_record->attributes = atol( row[7] );


}
return TRUE;
}

Answered by kishore , an ibibo Master, at 8:22 PM on May 15, 2008