Search Merchant Name / ID: Email / Mobile: Store Name: View All Zip / Area: PAN:     Admin: View Orders Query("select * from sl_users where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("select * from sl_users, stores where sl_users.uid=stores.uid order by stores.uid $order_by2",$debug=-1); $reccnt=$obj->numRows($sql); if($reccnt==0) { ?> No Record Records Found. fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?> S No. Merchant Name (id) Merchant Store (reg) Contact Details KYC Status Product Others . companyname; echo " ($line->uid)"; ?> uid; $sql3=$obj->query("select * from stores where uid=$uid order by uid $order_by2",$debug=-1); $sqlactpro=$obj->query("select * from tbl_product where uid=',$uid,' and status=1"); $sqldeactpro=$obj->query("select * from tbl_product where uid=',$uid,' and status=0"); $numactpro=$obj->numRows($sqlactpro); $numdeactpro=$obj->numRows($sqldeactpro); $i=0; while($line2=$obj->fetchNextObject($sql3)) { $i++; ?> Name:'.$line2->storename; ?> Name: ' .stripslashes($line->contactperson)." ".'Mobile: '.stripslashes($line->mobile)." ". 'Email: '.stripslashes($line->emailid)." ".'City: '.stripslashes($line->pdcity)." "; ?> PAN: '.stripslashes($line->pan)." ".'DOB: '.stripslashes($line->dobonpan)." ". 'Vat/CST: '.stripslashes($line->vatorcst)." ". 'A/c No.: '.stripslashes($line->accountno)." ". 'A/c type: '.stripslashes($line->accounttype)." ". 'Bank: '.stripslashes($line->bank)." "; ?> status==1){ ?> Total: joindate; ?>