Search Store Name / ID: Email / Mobile: Zip / Area: View All Admin: View Orders Query("select * from stores where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("select * from stores where 1=1 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. Store Name (id) Company Name (reg) Logo Contact Details Status Product Others . storename; ?> uid; $storeid=$line->storeid; $sql3=$obj->query("select * from sl_users 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->companyname; ?> Mobile: '.stripslashes($line->phone)." ". 'Email: '.stripslashes($line->email)." ".'City: '.stripslashes($line->city)." "; ?> in_stock==1){ echo "Active"; } else{ echo "Deactive"; } ?> Total: post_date; ?>