Access an array

Anon

Hi all,

I'm a bit of a newbie so please bear with me...

I want to get a whole table into an array so I can access individual columns once the loop has completed

So, I load the table into array...

while (mysql_fetch_row($result)) {

  $all[] = $result;

}

And now I need a function to access column 1, 2 and 3 here. I tried MYSQL_RESULT but it didn't work as I expected...

TIA

Mary

van__

lose this...

while (mysql_fetch_row($result)) {

$all[] = $result;

}

and use this...
<?
for ($i=0;$i<mysql_num_rows($result);$i++) {
$rows[$i] = mysql_fetch_array($result, MYSQL_ASSOC);
}

//here's your entire table in an array...
print_r($rows);
?>

to access say... row 27 column 'user_name':
<? echo $rows[27]['user_name']; ?>

Want all user_names?
<?
foreach ($rows as $key=>$val) {
echo $rows[$key]['user_name'] . "<BR>\n";
}
?>

Anon

Thank you Van - I'll try this out.

Anon

Van - thanks so much. This is a much better way. I've only used the ODBC functions before (ODBC_RESULT lets you get at the columns) and they did what I wanted but your way looks more efficient and readable.

You're a star!

van__

ODBC huh?
I used this for informix,
does the exact same thing that MySQL loop did.
<?
/
executes query and returns a hash table
ie: $reference->rowArr['fieldName'][row(int)]
/

$ex = @odbc_exec($crs,$sql);
$fetch = @odbc_fetch_into($ex,0,$odbcArr[0]);

$i=0;
while ($fetch) {
for ($x=1;$x<=@odbc_num_fields($ex);$x++) {
$rows[trim(@odbc_field_name($ex,$x))][$i] = $odbcArr[$i][$x-1];
} $i++;
$fetch = @odbc_fetch_into($ex,$i,$odbcArr[$i]);

}
}

print_r($rows)
?>

fun stuff 🙂