\n"; echo "

\n"; echo formatFestivalDate($r_days['date']) . " - $r_days[name]

\n"; echo "

\n"; $q_sch = mysqli_query($con, "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 1 AND start > str_to_date(addtime('$r_days[isodate] 00:00:00', '08:00:00'), '%Y-%m-%d %T') AND start < str_to_date(addtime('$r_days[isodate] 00:00:00', '32:00:00'), '%Y-%m-%d %T');"); //echo "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 1 AND start > str_to_date(addtime('$r_days[isodate] 00:00:00', '08:00:00'), '%Y-%m-%d %T') AND start < str_to_date(addtime('$r_days[isodate] 00:00:00', '32:00:00'), '%Y-%m-%d %T');"; //echo "SELECT festival_event.id AS id, gm, title_$lang AS title, description_$lang AS description, host, place, date_format(start, '%H:%i') AS st, date_format(end, '%H:%i') AS end, place.name_$lang AS place, address_$lang AS address, lat, lon FROM festival_event, place WHERE place.id = festival_event.place AND gm = 1 AND start > str_to_date(addtime('$r_days[isodate] 00:00:00', '08:00:00'), '%Y-%m-%d %T') AND start < str_to_date(addtime('$r_days[isodate] 00:00:00', '32:00:00'), '%Y-%m-%d %T');"; if (mysqli_num_rows($q_sch) > 0){ echo "\n"; while ($r_sch = mysqli_fetch_array($q_sch)){ echo "\n"; echo "

$r_sch[st]

$r_sch[title]\n"; //if (strlen($r_sch['end']) > 0){ // echo " ($r_sch[st] - $r_sch[end])\n"; //} echo "\n"; if (strlen($r_sch["description"]) > 0 && $r_sch["description"] != $r_sch["title"]){ echo "
$r_sch[description]\n"; } echo "\n"; //TODO: td for image, if any echo "\n"; //If name and address are the same, show only name if ($r_sch['place'] == $r_sch['address']){ echo "

$r_sch[place]

\n"; } else{ echo "

$r_sch[place] - $r_sch[address]

\n"; } echo "\n"; } echo "\n"; } echo "

\n"; echo "

\n"; } ?>

0){ echo "

$lng[lablanca_prices_days]

\n"; echo "\n"; while ($r_days = mysqli_fetch_array($q_days)){ echo "\n"; echo "\n"; } echo "

" . formatFestivalDate($r_days['date']) . " $r_days[price] €

\n"; $q_offers = mysqli_query($con, "SELECT id, name_$lang AS name, description_$lang AS description, price FROM festival_offer WHERE year = $year ORDER BY days;"); if (mysqli_num_rows($q_offers) > 0){ echo "

$lng[lablanca_prices_offers]

\n"; echo "\n"; while ($r_offers = mysqli_fetch_array($q_offers)){ echo "\n"; echo "\n"; } echo "

$r_offers[name]

$r_offers[description]

$r_offers[price] €

\n"; } } ?>