$yield = mysql_get_field('SELECT hotel_yield_percent FROM config WHERE id=(SELECT MAX(id) FROM config)'); do { if(!$prices1day = mysql_fetch_assoc($prices1day_res = mysql_query(' SELECT /* gArea, country, area,*/ hotel, stars, room, roomId, price meal, CAST(GROUP_CONCAT(meal,":",price/100*'.($yield+100).' SEPARATOR ",") AS CHAR) AS price, currency FROM globalArea ga INNER JOIN countries c ON ga.id = c.gAreaId INNER JOIN areas a ON c.id = a.countryId INNER JOIN hotels h ON a.id = h.areaId INNER JOIN rooms r ON h.id = r.hotelId INNER JOIN prices p ON r.id = p.roomId INNER JOIN meals m ON m.id = p.mealsId INNER JOIN currencies cur ON cur.id = p.currencyId WHERE ga.ok=1 AND c.ok = 1 AND a.ok = 1 AND h.ok = 1 AND r.ok = 1 AND p.ok = 1 AND m.ok = 1 AND cur.ok = 1 AND '.($_GET['h'] ? 'h.id = '.$_GET['h'] : 'a.id = '.$_GET['a']).' AND p.people = '.$_GET['p'].' AND fromDate <= "'.$from.'" AND upToDate >= "'.$from.'" GROUP BY roomId ORDER BY BINARY hotel, BINARY room'))) return msg('0No result found'); do { $prices_full[$prices1day['hotel']]['cat'] = $prices1day['stars']; $prices_full[$prices1day['hotel']]['cur'] = $prices1day['currency']; $prices_full[$prices1day['hotel']]['rooms'][$prices1day['room']]['rId'] = $prices1day['roomId']; $price = s2a_key($prices1day['price']); foreach($price as $key => $val) { $prices_full[$prices1day['hotel']]['rooms'][$prices1day['room']][$key] = $val; ++$prices_full[$prices1day['hotel']]['rooms'][$prices1day['room']][$key.'D']; } }while($prices1day = mysql_fetch_assoc($prices1day_res));