Het out values from a MySQL array

[fabiuz]

Hi,

I still have some mess in my mind regarding Arrays... I have one of them similar of this:

$result = mysql_query($sql);

I usually use mysql_fetch_array with a While to get out values, but is it possible to get out values in other ways using PHP array functions like each() ?

If yes, how ?

I have this problem because I want to merge more arrays togheter, clean double values and then print it's content...

Thamk you !

[rharter]

while ($row = mysql_result($result) {
foreach ($row as $val) {
echo $val;
}
echo '<br/>';
}

should loop through your results one row at a time and
echo each field

[rinjani]

You can use list:

$result = mysql_query($sql);
list($var[0], $var[1], $var[2]) = $result;

OR

while ((list($var1, $var2, $var3) = mysql_fetch_row ($result)) {

//DO SOMETHING

}

HTH