'."\n"; echo ''."\n"; echo ''."\n"; echo ' Gigoit Inc :: Last 1000 Offers'."\n"; echo ' 1'."\n"; echo ''."\n"; echo ' gigoit_earth_offers.kml'."\n"; echo ' 1'."\n"; echo ' '."\n"; ## QUERY OFFERS $sql = "SELECT `offer`.`pid` AS offerid, `offer`.`fk_poster`, `offer`.`body`, `offer`.`category`, `offer`.`status`, `offer`.`modified`, `offer`.`title`, `data_postal_code`.`latitude`, `data_postal_code`.`longitude`, `offer`.`fk_postal_code`, `offer`.`fk_language`, `offer`.`fk_country`, `data_postal_code`.`postal_code`, (SELECT `offer_picture`.`filename` FROM `offer_picture` WHERE `offer_picture`.`fk_offer_pid` = `offer`.`pid` LIMIT 1) AS firstThumb FROM `offer` Left Outer Join `data_postal_code` ON `data_postal_code`.`postal_code` = `offer`.`fk_postal_code` ORDER BY `offer`.`pid` DESC LIMIT 10000;"; if($result = $db_connection->query($sql)){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ if($row['firstThumb'] != '') { echo ' '."\n"; } } } if($result = $db_connection->query($sql)){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ if($row['longitude'] != '' && $row['latitude'] != ''){ if($row['firstThumb'] != ''){ $style = '#gigoit_offer_'.$row['offerid']; $filename = 'http://media.gigoit.org/offer_images/post_images/full/'.$row['firstThumb'].'.jpg'; } else { $style = '#gigoit_offer_default'; $filename = 'http://media.gigoit.org/images/items/noimage,0.gif'; } echo ' '."\n"; echo ' '."\n"; echo '
View OfferOffered By: '.$row['fk_poster'].'
Status: '.$row['status'].'
Category: '.$row['category'].'
Modified: '.$row['modified'].'
Description: '.$row['body'].']]>'."\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 ' '.$style.''."\n"; echo ' '."\n"; echo ' '.$row['longitude'].','.$row['latitude'].',0'."\n"; echo ' '."\n"; echo ' '."\n"; } } } echo ''."\n"; echo ''."\n"; echo ''."\n"; ?>