Answer / vijay kumar singhal

wrong, instead both returns all the rows from table. The
difference between them is fetch_array return result in
assoc array as well as numeric array and you can also
specify which specific type of array you want by providing
second paramter to the function while fetch_row return
result in numeric array only.

fetch_row : Array( [0]=>vijay)
fetch_array : Array([0]=>vijay [name]=>vijay)

Answer / srinivas1982

sorry for my mistake. here is the answer
the functions mysql_fetch_row(), mysql_fetch_array() and
mysql_fetch_object() return one row from the result, and
then move the pointer on. If there are no more rows to
fetch, it returns false. This means you can you use a very
simple while loop:

$result=mysql_query("SELECT * FROM sometable");
while($row=mysql_fetch_row($result)){
do_something_with_row();
}

This will automatically terminate when the last row has been
processed.

the difference between mysql_fetch_row() and
mysql_fetch_array() is that the first returns the results in
a numeric array ($row[0], $row[1] etc), while the latter
returns a the results an array containing both numeric and
associative keys ($row["name"], $row["email"] etc).
mysql_fetch_object() returns an object ($row->name,
$row->email etc).

Answer / tarun singhal

mysql_fetch_array: returned a row from recordset as a
numeric and/or associative array.

mysql_fetch_row: returned a row from recordset as numeric array.

example:
$con=mysql_connect("localhost","root","root");
$sql = "select * from member where id=1";
$result=mysql_query($sql,$con);
print_r(mysql_fetch_array($result));
print_r(mysql_fetch_row($result));

Answer / piyush patel

mysql_fetch_array:

This function return row as an associative array, a numeric
array, or both. you can refer to outputs as databases
fieldname rather then number.
example :
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
print "$row['name']";
print "$row['mobile']";
}

mysql_fetch_row :

This function return row as an enumrated array and each row
contain a unique ID.
example:
$result=mysql_query($query);
while($row=mysql_fetch_row($result))
{
print "$row[0]";
print "$row[1]";
print "$row[2]";
}

Answer / sowmya mn

mysql_fetch_assoc — Fetch a result row as an associative array
mysql_fetch_array — Fetch a result row as an associative
array, a numeric array, or both
mysql_fetch_row — Get a result row as an enumerated array

Answer / amit

mysql_fetch_array() will return result row as associative or
nueric array or both.While mysql_fetch_row() will return
result row as array & return only single row.

Answer / 585858

mysql_fetch_array()works as an associative array i.e. just
use the field name specified in your database to access the
values while mysql_fetch_row() returns the value of a
single field in a particular row if you r going to specify
the array's index which starts from '0'.

Answer / sekhar

mysql_fetch_array($resultset, [return type]);
return a row from the result set as an array
return type values:
MYSQL_NUM If return type is mysql_num, we have to use the
column position in the result set.
MYSQL_ASSOC: if return type is mysql_assoc, we have to fetch
the data by using column names in result set.
MYSQL_BOTH: if return type is mysql_both, we have to fetch
the data by using column index or column names in the result
set.

mysql_fetch_rows($resultset);
retrives the row from the result set and move the pointer to
the next record.
we have to retrive the data from the row by using the filed
position in the result set.

mysql_fetch_assoc($resultset);
retrives a row from the resultset as an associative array.
we have to retrive the data by using the columns name in the
result set.

mysql_fetch_object($resultset);
return the row as an object. we have to fetch the data in
the row fetch the column names in the result set as $row->
column name in the result set.

Answer / deepaa

There is not so much difference between the
mysql_fetch_array and mysql_fetch_assoc in the sense that
both can fullfill your requirements but it depends on your
need and ease of use. I prefer mysql_fetch_array because
with it i can use both indexed value and associative value.

I will explain this difference with short example:
$sql = mysql_fetch_array(‘select name, address from
tbl_customer’);
It means that you are getting answer directly into an array
, and you dont need to know the field value of the elements
to be outputed.
Just print the output as:

foreach($sql as $ans){
echo $ans[0].' lives in '.$ans[1];
}
or
foreach($sql as $ans){
echo $ans['name'].' lives in '.$ans['address'];

}

mysql_fetch_assoc, you can output the result as $ans['name']
but not $ans[0] . What i want say is you need to know about
the field name of the table. Ok here is the sample code:

foreach($sql as $ans){
echo $ans['name'].' lives in '.$ans['address'];
}
But not
foreach($sql as $ans){
echo $ans[0].' lives in '.$ans[1];

}

Answer / prabhu

how to fetch the particular row in multiple rows in phpmysql?

What is data type in php?

0 Answers  

What is a composer?

0 Answers  

Are sessions stateless?

0 Answers  

How do you sort an array in php?

0 Answers  

Is salary fixed or variable cost?

0 Answers  

Explain how to submit form without a submit button.

0 Answers  

Where php basically used?

0 Answers  

What language is similar to php?

0 Answers  

What is the difference between Session and Cookie?

0 Answers  

Explain about require and include function?

0 Answers  

Why do you need to filter out empty files?

0 Answers  

Hi all, I have a problem in Apache on windows xp.I tried to unistall apache and install it again. But when in did the installation again, and tried to run apache, i get the following error message, Socketaddresse can just be used once. Make_sock: could not build to address 0.0.0.0.80 No listening sockets available.Shutting down Unable to open logs. and i also get (error) OS2. The system cannot fine the installed service named "Apache2". Please i need some one to help me out with this.I'm really fustrated cuz i need this stuff working as fast as possible. PLEASE HELP ME

2 Answers