0 "; } if($cid == "" or $cid == 0) $filter = ""; else $filter = " and commodityid = " . $cid; $m_month = explode(",","Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"); $sql="select max(date_format(entrydate, '%Y-%m-%d')) as entrydate from LatestExchRates"; $q->query($sql); $q->next_record(); $date=$q->f('entrydate'); $sql = "select exchvarid, exchvarietyname, LatestExchRates.exchangeid, exchangename, futureyear, futuremonth, projection, spottxt, last, buy, sell, last - settlementprice as changeval, chgn, settlementprice, open, high, low, (last*volume) as value, volume, entrydate, entrytime, LatestExchRates.settleflag, (last - settlementprice)/settlementprice*100 as perchgn from LatestExchRates, ExchangeMaster, ExchVarietyMast where LatestExchRates.exchangeid in (33) and LatestExchRates.exchangeid = ExchangeMaster.exchangeid and exchvarid = exchvarietyid and date_format(entrydate, '%Y-%m-%d') = '".$date."' ".$mysql3.$filter.$order; $q->query($sql); $common_top=join(" ", file("http://127.0.0.1/eagritrader/home_menu.php?ref=$referer&err=$err&login=$login&subs_opt=$subs_opt&userid=$userid&cid=$cid")); $ctr = 1; echo $common_top; echo "

	"; echo ""; while($q->next_record()) { if($ctr == 1) { if($type=="v"){ $colp="7"; } else{ $colp="6"; } echo ""; echo ""; echo""; if($type=="v"){ echo ""; } } echo ""; echo""; if($type=="v"){ echo ""; } echo ""; $ctr++; } /* $sql = "select exchvarid, exchvarietyname, LatestExchRates.exchangeid, exchangename, futureyear, futuremonth, projection, spottxt, last, buy, sell, last - settlementprice as changeval, chgn, settlementprice, open, high, low, volume, entrydate, entrytime, LatestExchRates.settleflag, (last - settlementprice)/settlementprice*100 as perchgn from LatestExchRates, ExchangeMaster, ExchVarietyMast where LatestExchRates.exchangeid in (33) and LatestExchRates.exchangeid = ExchangeMaster.exchangeid and exchvarid = exchvarietyid and date_format(entrydate, '%Y-%m-%d') = date_format(now(), '%Y-%m-%d') and ((last - settlementprice)/settlementprice*100) < 0 " . $filter . " order by perchgn asc, volume desc, exchangename desc, projection, futureyear, futuremonth limit 0,5"; $q->query($sql); $ctr = 1; while($q->next_record()) { if($ctr == 1) { echo ""; echo ""; } echo ""; $ctr++; } */ if($ctr == 1) { echo ""; } echo " " . $q->f("exchangename") . " Top $volumn Gainer Variety Contract Last Chg % Chg Volume  Value in Cr " . $q->f("exchvarietyname") . " " . $m_month[$q->f("futuremonth")-1] . "'" . substr($q->f("futureyear"),2) . " " . number_format($q->f("last"),2,".","") . " " . number_format($q->f("changeval"),2,".","") . " " . number_format($q->f("perchgn"),2,".","") . " " . $q->f("volume") . "  " . $q->f("value") . " " . $q->f("exchangename") . " Top Losers Variety Contract Last Chg % Chg Volume " . $q->f("exchvarietyname") . " " . $m_month[$q->f("futuremonth")-1] . "'" . substr($q->f("futureyear"),2) . " " . number_format($q->f("last"),2,".","") . " " . number_format($q->f("changeval"),2,".","") . " " . number_format($q->f("perchgn"),2,".","") . " " . $q->f("volume") . " No gainers found		"; if($type=="v"){ $common_footer=join(" ", file('http://127.0.0.1/eagritrader/common/footer_mcx.php?pages=MTVG&cid=$cid&varid=$varid&top=3')); } else{ $common_footer=join(" ", file('http://127.0.0.1/eagritrader/common/footer_mcx.php?pages=MTG&cid=$cid&varid=$varid&top=1')); } echo "
".$common_footer."

"; ?>