'."\n"; echo ''."\n"; echo ''."\n"; echo ' Gigoit Inc :: Summary'."\n"; echo ' 1'."\n"; echo ''."\n"; echo ' gigoit_earth_summary.kml'."\n"; echo ' 1'."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; ## QUERY OFFERS $sql = "SELECT COUNT(offer.fk_zip) AS quantity, offer.fk_zip, zips.latitude, zips.longitude FROM offer LEFT JOIN zips ON offer.fk_zip = zips.zip WHERE offer.status IN ('available','pendingconfirm') GROUP BY offer.fk_zip ORDER BY quantity DESC"; if($result = $db_connection->query($sql)){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ if($row['longitude'] != '' && $row['latitude'] != ''){ ## SET STATUS ICON $icon = '#gigoit_tiny'; if($row['quantity'] >= 25){ $icon = '#gigoit_large'; } else if($row['quantity'] >= 12 && $row['quantity'] < 25){ $icon = '#gigoit_med'; } else if($row['quantity'] >= 5 && $row['quantity'] < 12){ $icon = '#gigoit_small'; } else if($row['quantity'] >= 1 && $row['quantity'] < 4){ $icon = '#gigoit_tiny'; } echo ' '."\n"; echo ' '."\n"; echo '
View Items]]>'."\n"; echo ' '."\n"; echo ' '.$row['longitude'].''."\n"; echo ' '.$row['latitude'].''."\n"; echo ' 0'."\n"; echo ' 3482723.18754794'."\n"; echo ' 0'."\n"; echo ' -3.181699366958458'."\n"; echo ' '."\n"; echo ' '.$icon.''."\n"; echo ' '."\n"; echo ' '.$row['longitude'].','.$row['latitude'].',0'."\n"; echo ' '."\n"; echo ' '."\n"; } } } echo ''."\n"; echo ''."\n"; echo ''."\n"; ?>