='$tday' and fromdate LIKE '%$y-$m%' order by fromdate"; $result_count = @mysql_query($query_count); $totalrows = @mysql_num_rows($result_count); if(empty($page)) { $page = 1; } $limitvalue = $page * $limit - ($limit); $query = "select * from addshow where status='Approved' and todate>='$tday' and fromdate LIKE '%$y-$m%' order by fromdate LIMIT $limitvalue, $limit"; $result = @mysql_query($query); $numrows = @mysql_num_rows($result); if($numrows == 0) { ?>
No Trade Shows










.html" style="font-weight:600;">
Start Date :   End Date :
Highlights :
Venue : ,
Country :
.html" style="background: #FF5600;padding: 3px;color: white;border-radius: 2px; border: 1px solid #E04C00;">» Click here for Details








Page No. [PREV] "); } else { } $numofpages = $totalrows / $limit; for($i = 1; $i <= $numofpages; $i++) { if($i%30 == "1") { ?> " . $i . " "); } else { echo(" $i "); } } if(($totalrows % $limit) != 0) { if($i == $page) { echo(" " . $i . " "); } else { echo(" $i "); } } if(($totalrows - ($limit * $page)) > 0) { $pagenext = $page + 1; echo(" [NEXT]"); } else { } ?>