George Adams Gallery "> ='$yr-$mhonap-$mnap 00:00:00' order by begin"); $ossz_exh=mysql_num_rows($exhibi); if($ossz_exh==0){ $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin>='$yr-$mhonap-$mnap 00:00:00' and exhibitions.end>='$yr-$mhonap-$mnap 00:00:00' order by begin"); } $ossz_exh=mysql_num_rows($exhibi); if($ossz_exh==0){ $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin>='$yr-09-01 00:00:00' order by begin"); } $ossz_exh=mysql_num_rows($exhibi); if($ossz_exh==0){ $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin<='$yr-09-01 00:00:00' order by begin desc"); } /* $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin<='$yr-$mhonap-$mnap 00:00:00' and exhibitions.end>='$yr-$mhonap-$mnap 00:00:00' order by begin"); $ossz_exh=mysql_num_rows($exhibi); if($ossz_exh==0){ $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin>='$yr-01-01 00:00:00' order by begin"); } $ossz_exh=mysql_num_rows($exhibi); if($ossz_exh==0){ $exhibi=mysql_query("select exhibitions.id from exhibitions join artists where artists.id=exhibitions.artist and exhibitions.begin<='$yr-01-01 00:00:00' order by begin desc"); } */ $akt=mysql_fetch_row($exhibi); $exhib=$akt[0]; // pdf $pdf=mysql_query("SELECT * from pdf WHERE artist='$exhib' and art_exh='e'"); $pdf_o=mysql_num_rows($pdf); // pdf END $artmagassag=40; $artists=mysql_query("select begin,end,artists.name,exhibitions.title,press_release,recep from exhibitions left join artists on artist=artists.id where exhibitions.id=$exhib"); $r=mysql_fetch_row($artists); $kepek=mysql_query("select exhib,pic,realpic from pictures join exhibpic where exhibpic.realpic=pictures.id and exhib=$exhib order by pic"); $ossz=mysql_num_rows($kepek); $sorok=ceil($ossz/3); $szorzo=200; $magassag=($sorok*$szorzo)+70+$artossz*12; ?>
"; $sorsz=2; }elseif($sorsz==2){ echo ""; $sorsz=3; }elseif($sorsz==3){ echo ""; $sorsz=1; } } if($sorsz==2){ echo " "; } if($sorsz==3){ echo " "; } } ?>
"; echo ""; }elseif($sorrend==2){ echo ""; } $exhib=$akt_kiall[0]; $artists=mysql_query("select begin,end,artists.name,exhibitions.title,press_release,recep,exhibitions.id from exhibitions left join artists on artist=artists.id where exhibitions.id=$exhib"); $r=mysql_fetch_row($artists); echo ""; } echo ""; echo "
"; while($akt_kiall=mysql_fetch_row($exhibi)){ $sorrend++; if($sorrend==1){ $start=explode(" ",$r[0]); $end=explode(" ",$r[1]); $s=explode("-",$start[0]); $e=explode("-",$end[0]); echo "
".date("M j",mktime(0,0,0,$s[1],$s[2],$s[0]))." - ".date("M j, Y",mktime(0,0,0,$e[1],$e[2],$e[0]))."

Main Gallery

Drawing Gallery

"; $kepek=mysql_query("select exhib,pic,realpic from pictures join exhibpic where exhibpic.realpic=pictures.id and exhib=$exhib order by pic"); if ($kepki = mysql_fetch_row($kepek)) { echo "

"; } if($r[2]!="Multi"){ $nev_e=explode("(",$r[2]); echo "$nev_e[0]
";}?> "; ?> Opening reception: $r[5]"; } echo "
"; }else{ if($r[2]!="Multi"){ $nev_e=explode("(",$r[2]); echo "$nev_e[0]
";}?> "; ?> Opening reception: $r[5]"; } } ?>
Press release"; } // pdf if($pdf_o>0){ $pdf1=mysql_query("SELECT pdf.id,pdf.link,exhibitions.id from pdf join exhibitions WHERE pdf.artist=exhibitions.id and pdf.artist=$exhib and art_exh='e'"); //echo "SELECT pdf.id,pdf.link,exhibitions.id from pdf join exhibitions WHERE pdf.artist=exhibitions.id and pdf.artist=$exhib and art_exh='e'"; while ($pdf_data1 = mysql_fetch_row($pdf1)) { $path="../exhibitions/e".$pdf_data1[2]."/pdf/".$pdf_data1[0]."_art.pdf"; } echo "
Press / Articles
"; }; // pdf END ?>