break this code down into laymen terms for me please

sean_paul

function db_result_to_array($result)
{
$res_array = array();

for ($count=0; $row = @mysql_fetch_array($result); $count++)
$res_array[$count] = $row;

return $res_array;

}

I don't understand the "$res_array[$count]= $row"
statement

To see what the res array equals what kind of echo statement should I write

Mystis

This function returns database reults to an array. If you'd like to view the results, use a foreach statement.

$results = db_result_to_array($executed_sql_query);
foreach($results as row){
echo "Row ID: ".$row['id']."<br />Row field 1:".$row['field1']."<br /><br />";
}

Untested code, but something like that should work.
http://www.php.net/manual/en/control-structures.foreach.php

The $res_array[$count]= $row statement simply adds the contents of the row into a new entry in the array $res_array.

tomhath

What Mystis said is right, but the function itself semms very strange and inefficient IMHO.

Why store the rows in an array? Just use $result, or at least break them out into columns when fetching them the first time instead of storing the keys over and over again (an associative array for every row??? Am I missing something here?).

Mystis

Originally posted by tomhath
What Mystis said is right, but the function itself semms very strange and inefficient IMHO.

Why store the rows in an array? Just use $result, or at least break them out into columns when fetching them the first time instead of storing the keys over and over again (an associative array for every row??? Am I missing something here?).

I agree, and doesnt mysql_fetch_array do that exact same thing?

nemonoman

A little editing is in order.

function db_result_to_array($result)
{
$res_array = array();
for ($count=0; $row = @mysql_fetch_array($result); $count++)
{$res_array[$count] = $row;} //added braces here
return $res_array;
}

Now the function makes sense.

You could simplify and just create $res_array on the fly, this way.

function db_result_to_array($result)
{ for ($count=0;$res_array[]= @mysql_fetch_array($result); $count++)
return $res_array;
}

I've got a function sort of like this in most of my code; others probably have a similar one. You'd use it like this:

$result=mysql_query('SELECT * FROM table');
$resultarray=db_result_to_array($result) ;

then manage the $resultarray however you please.

Or even:
$resultarray=db_result_to_array(mysql_query('SELECT * FROM table')) ;