|  | 
     
        |   |  
        | 
  
    | 
          
            | Trade Shows in India |  
            | 
                
                  
                      $show="select city_id,city_name from hp_city order by city_name asc";
                      $citi=mysqli_query($show); 
                      while ($fec=mysqli_fetch_array($citi)) 
                      {
                       ?>
                        echo $fec[city_name]; ?>} ?> |  | $cname="select city_id,city_name from hp_city order by city_name asc";
			$cycle=mysqli_query($cname); 
			$i=0;
			while ($sec=mysqli_fetch_array($cycle)) 
			{
				$sql1="select * from hp_tradeshow where cityid='".$sec['city_id']."'";         
				$query1=mysqli_query($sql1);                        
				$rec1=mysqli_fetch_array($query1);	
		?> 
 
		
			}
		   ?>
				| if ($i=="1") { ?>
						top
					 } $i=1; ?>
					 echo $sec[city_name]; ?> |  
				} else { ?>
		 } ?>
	
          
			$sql="select   DATE_FORMAT(from_next_dt,'%d %b') as from_next_dt,DATE_FORMAT(from_next_dt,'%Y-%m-%d') as from_next_dta,DATE_FORMAT(end_next_dt,'%Y-%m-%d') as end_next_dtb, DATE_FORMAT(end_next_dt,'%d %b, %Y') as end_next_dt    ,trade_show_id,cityid,exhibition_name,description,location,cycle from hp_tradeshow 
                                        where cityid='".$sec[city_id]."'  order by from_next_dta,end_next_dtb  asc";         
                                  $query=mysqli_query($link,$sql);                        
                                  while ($rec=mysqli_fetch_array($query))
                                   {
									if($rec['cityid']== $sec[city_id])
									{
                          ?>| Exhibition Name | Next Date |  
			
		  | echo $rec[exhibition_name];  ?>/* | //echo $rec[cycle];*/ ?> | echo $rec[from_next_dt]." - ".$rec[end_next_dt];  ?> |  
            | echo $rec[description];  ?> |  
            |   Venue :  echo $rec[location];?> |  |  |              
            }
			}
		   ?>|  |  |  
        |  |  |  |  |  |