' ' ORDER BY City, Price"; $sql_result = mysql_query($sql,$connection) or print $mysql_error(); $i = 0; While ($row = mysql_fetch_array($sql_result)) { $photo1[$i] = $row["Photo1"]; $id[$i] = $row["ID"]; $city[$i] = $row["City"]; $address1[$i] = $row["Address1"]; $openhouse[$i] = $row["open_house"]; $price[$i] = $row["Price"]; ++$i; } ?> Open Houses
   

ID

City Address Open House Date

Price

>DETAILS

 

     

$