fetch_row and fetch_array

[dkode]

I commonly use mysql_fetch_row();

When I run this command within a while statement it dumps the row into $result (array)

What is the difference between using fetch_row and the other methods of retrieving response? such as fetch_array? And what are all the fetch options I have to choose from?

[Robo]

There isn't much difference between mysql_fetch_array and mysql_fetch_row, except mysql_fetch_array was designed to get multiple rows, eg.

$sql = mysql_query("SELECT column FROM table...") or die (mysql_error());

while ($row = mysql_fetch_array($sql)) {
extract($row);
$something[] = $column;
} 

That will store all the rows found into the array $something.

I ususally just use mysql_fetch_array since if there's only one result, the speed difference isn't noticeable between fetch array and fetch row.

[freddydoesphp]

mysql_fetch_array and mysql_fetch_row do exactly the same thing. There is no difference. In fact the only difference is fetch_row returns the array with numerical indices like

while($row = mysql_fetch_row($result)) {
print $row[0];
} 

While mysql_fetch_array() returns both numerical and named indices like:

while($row = mysql_fetch_row($result)) {
print $row['fieldname'];
//or
print $row[0];
}
//these will prdocue the same results. 

On a side note mysql_fetch_array() takes an optional param of what kind of result to return.

mysql_fetch_row($result, MYSQL_ASSOC)
//Returns only named indices 

mysql_fetch_row($result, MYSQL_NUM)
//Returns only numbered indices 

mysql_fetch_row($result, MYSQL_BOTH)
//Returns both same as
mysql_fetch_row($result) 

[dkode]

freddy,

in your examples there:

while($row = mysql_fetch_row($result)) {
print $row['fieldname'];
//or
print $row[0];
}
//these will prdocue the same results. 

Don't you mean this to be:

while($row = mysql_fetch_array($result)) {
print $row['fieldname'];
//or
print $row[0];
}
//these will prdocue the same results. 

Or did you mean to put mysql_fetch_row?

[DR_LaRRY_PEpPeR]

yes dkode, it's supposed to be fetch_array() as fetch_row() only makes numerical indexes. just a mistake...

[freddydoesphp]

Thanks for catching that, mistake on my part. Should have been array like Dr. said.