|
|
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]; ?>
|
Exhibition Name |
Next Date |
} 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])
{
?>
echo $rec[exhibition_name]; ?> |
/* //echo $rec[cycle]; | */ ?>
echo $rec[from_next_dt]." - ".$rec[end_next_dt]; ?> |
echo $rec[description]; ?> |
Venue : echo $rec[location];?>
|
|
|
|
}
}
?>
}
?>
|
|
|
|
|
|