query(“SELECT * FROM repeater_list”);
//$number_of_rows = mysql_num_rows($db);
//echo $number_of_rows;
while( $row = $query->fetch_assoc() ){
$name = $row[‘NAME’];
$latitude = $row[‘LAT’];
$longitude = $row[‘LON’];
$link=$row[‘NETWORK’];
$tx=$row[‘TX’];
$rx=$row[‘RX’];
$cc=$row[‘CC’];
$callsign=$row[‘CALLSIGN’];
$idx=$row[‘IDX’];
$covmap=$row[‘COVMAP’];
/* Each row is added as a new array */
$locations[]=array( ‘NAME’=>$name, ‘LAT’=>$latitude, ‘LON’=>$longitude, ‘NETWORK’=>$link, ‘TX’=>$tx, ‘RX’=>$rx, ‘CC’=>$cc, ‘CALLSIGN’=>$callsign, ‘IDX’=>$idx, ‘COVMAP’=>$covmap );
}
//echo $locations[0][‘NAME’].”: In stock: “.$locations[0][‘LAT’].”, sold: “.$locations[0][‘LON’].”.
“;
//echo $locations[1][‘name’].”: In stock: “.$locations[1][‘lat’].”, sold: “.$locations[1][‘lng’].”.
“;
?>