<?php
    $exhibitionslug = EXHIBITION_TITLE;
        
//$exhibitionid = getExhibitionFromTitle($exhibitionslug);        
       
        $alltable = new AllTables();
        $sql = "select * from mstexhibition where siteid = '2' ";
        $data = $alltable->getInfo_mainconnection('', $sql);
        $count = count($data);
        
        $record = '';
        
        if($count > 0)
        {
            for($i=0;$i<$count;$i++)
            {
                $exhibitiontitle                            = $data[$i]['exhibitiontitle'];
                $exhibitionid                               = $data[$i]['exhibitionid'];

                $exhibitiondescription                      = $data[$i]['exhibitiondescription'];
                $status                                     = $data[$i]['status'];
               
                $exhibitioncategory                         = $data[$i]['exhibitioncategory'];
                $exhibitionlogo                             = $data[$i]['exhibitionlogo'];
                $exhibitionreportpdf                        = $data[$i]['exhibitionreportpdf'];////brochure
                $postshowreportpath                         = $data[$i]['postshowreportpath'];////post show report
                $exhibitorlistpdf                           = $data[$i]['exhibitorlistpdf'];////exhibitor list pdf
                $exhibitorapplicationformpdf                = EXHIBITION_REPORTPHOTO_PATH.$data[$i]['exhibitorapplicationformpdf'];
                $exhibitionvenue                            = $data[$i]['exhibitionvenue'];
                $city                                       = $data[$i]['exhibitioncity'];
                $country                                    = $data[$i]['exhibitioncountry'];
                $fodate                                     = $data[$i]['exhibitionfromdate'];
                $todate                                     = $data[$i]['exhibitiontodate'];
                $contact_no                                 = $data[$i]['contact_no'];
                $exhibitionlogo                             = EXHIBITION_PHOTO_THUMB_PATH.$exhibitionlogo;//exhibition logo
                $exhibitionbanner                           = EXHIBITION_PHOTO_THUMB_PATH.$data[$i]['exhibitionTopBanner'];
                $exhibition_venue                           = $exhibitionvenue .", ". $city.", ". $country;
                $brochure                                   = EXHIBITION_REPORTPHOTO_PATH.$exhibitionreportpdf;//brochure
                $postshowreport                             = EXHIBITION_REPORTPHOTO_PATH.$postshowreportpath;
                $descriptiontitle                           = $data[$i]['descriptiontitle'];
                $safetyguidelinespdf                        = EXHIBITION_REPORTPHOTO_PATH.$data[$i]['safetyguidelinespdf'];//safetyguidelinespdf
                $exhibitionTopBanner_mobileview             = EXHIBITION_PHOTO_THUMB_PATH.$data[$i]['exhibitionTopBanner_mobileview'];
               

            }
        }    ?>
