decid($strid):''; if($strid==''){ echo ""; exit; } $ss_info = $db->singlerec("select success_stories.*,company.name as cname,company.id as cid,company.registration_date,company.type as ctype,company.street as cstreet,company.city as ccity,company.category as cat,company.main_product1 as mainprod1,company.main_product2 as mainprod2,company.main_product3 as mainprod3,company.main_product4 as mainprod4,company.country as ccode from success_stories,company where success_stories.user_id = company.user_id AND success_stories.status='1' AND success_stories.id=$strid order by success_stories.crcdt DESC"); $country = $db->singlerec("select nicename,iso from countries where id='".$ss_info['ccode']."' LIMIT 1"); $userdet = $db->singlerec("select fname,lname from register where id = '".$ss_info['user_id']."'"); $fcat=$db->singlerec("select category_name from category where id='".$ss_info['cat']."'"); $cat=ucwords($fcat['category_name']); if(file_exists("uploads/success/".$ss_info['story_photo'])){ $logourl = "$siteurl/uploads/success/".$ss_info['story_photo']; }else{ $logourl = "$siteurl/uploads/success/noimage.jpg"; } ?>