Using foreach to print SQL results array?

[livewire1974]

hi,
Is this possible? Or am I missing something?

Here is my code..

$query2 = "SELECT * FROM employer";
$result2 = mysql_query($query2);

echo mysql_num_rows($result2);

foreach ($result2 as $key=>$value) { 
echo $value;

}

This is not printing anything?

thanks for your time..

[guido2004]

A mysql result set is not an array. You can't use foreach. Use while instead, and get one row at a time from the result set with mysql_fetch_array:
http://www.php.net/manual/en/functio...etch-array.php

[Jake Arkinstall]

If you were using the PDO library rather than MySQL, you could do it.

With MySQL you use MySQL_Fetch_Assoc/Array:

$employerQuery = 'SELECT * FROM employer';
$employerResult = MySQL_Query($query2);
while($row = MySQL_Fetch_Assoc($employerResult)){ 
    //$row is now an array, containing the fields for that row:
    echo $row['Name']; //gets the Name of this row
} 

That will repeat for every result found.

[livewire1974]

cool, thanks for the advice guys!!