leggere una query con foreach

[gasparroa]

dovrei sostituire i dati provenienti da due query

$beenTo=$catquery1=mysql_query("SELECT * FROM prova order by nome asc")or die("Query non valida" .mysql_error);

e $places=$catquery2=mysql_query("SELECT * FROM prova1 order by nome asc")or die("Query non valida" .mysql_error);

e cosi via

<?php
$beenTo = array("Rome","Underpants"); 
$places = array("Rome","France","Underpants","s","s","s","s","s","s","s","s"); 
?>

 <select multiple="multiple"> <?php 
foreach($places as $place) { 
    echo "<option"; 
    $found = false; 
    foreach($beenTo as $placeBeenTo) { 
        if ($placeBeenTo == $place) { 
            $found == true; 
            echo " selected=\"selected\">"; 
            break; 
        } 
    } 
    if (!$found) echo ">"; 
    echo $place . "</option>"; 
}