52000) { $id=$_REQUEST['compid'] - 52000 ; }else{ header("location:https://www.eindiabusiness.com/");exit; } //============================================================================== $fetch=mysql_query($ff="select a.city,a.state,a.country,a.businessdes,b.companyname,a.email,a.phone,a.comp_address,a.contact_person from cms_company_details a,cms_company_master b where a.comp_id=b.comp_id and b.company_isactive=1 and a.comp_id='$id'"); if(mysql_num_rows($fetch)==0){ header("location:https://www.eindiabusiness.com/");exit; } $rs=mysql_fetch_array($fetch); $businessdesc=$rs['businessdes']; $companyname=$rs['companyname']; $city=$rs['city']; $state=$rs['state']; $country=$rs['country']; $Company_Name=$rs['companyname']; $Comp_Contact_Person=$rs['contact_person']; $Comp_Address=$rs['comp_address']; $Comp_City=$rs['city']; $Comp_Pin=$rs['pin']; $Comp_State=$rs['state']; $Comp_Country=$rs['country']; $Company_Phone=$rs['phone']; $Company_Email=$rs['email']; $memurl = str_replace(" ", "-", $companyname); $memurl =preg_replace('/[^A-Za-z0-9\-\']/', '', $memurl); $memurl = strtolower($memurl).".html"; $selcats=mysql_query("select category,subcategory from cms_listing_master_category where comp_id='$id' order by id desc limit 0,1") or die(mysql_error()); $cat=mysql_fetch_array($selcats); $catsprod=$cat['category']; $scatsprod=$cat['subcategory']; //============================================================================== $selcontact=mysql_query("select category,subcategory from cms_listing_master_category where comp_id='$id' order by subcategory asc limit 0,20") ; ?> <? echo ucwords($Company_Name)?> <? echo ucwords($catsprod); ?> <? echo ucwords($Comp_City); ?>

, ,



COMPANY PROFILE




PRODUCT RANGE

SIGN IN TO MYEIB

Forgot Password? Freelist Your Company





Tell Us What You Are Looking For?


REACH US


 



- , ,

MY PRODUCTS


RECOMMENDED PRODUCTS

'' and prod_name<>'' and clienttype<>'Business Free' and clienttype<>'' and category='$catsprod' group by comp_id order by rand() limit 0,6"); // echo $ss; while($imgrk=mysql_fetch_array($selimg)){ $companynamexx=$imgrk['companyname']; $list_image=$imgrk['list_image']; $prod_namexx=$imgrk['prod_name']; $url=$imgrk['url']; $ipath="https://www.eindiabusiness.com/list_img/".$list_image; ?>

RELATED PRODUCTS / SERVICES


RELATED COMPANY

'' and category='$catsprod' and subcategory='$scatsprod' group by comp_id order by clienttype,RAND( ) limit 0,200"); while($vsv=mysql_fetch_array($selcontactv)){ $surl=$vsv['url']; if($vsv['clienttype']=='Business Free'){ $goid=$vsv['comp_id'] + 52000; $cmpurl=str_replace(" ","-",strtolower($vsv['companyname'])); $surl="https://www.eindiabusiness.com/company/$goid/$cmpurl.html"; } ?>