ob_start(); session_start(); include('includes/dbconfig.php'); include('includes/constants.php'); $_SESSION['profession']=$_REQUEST['profession']; extract($_REQUEST); $limit = '5'; if($_GET['start']!='') { $start = $_GET['start']; } else { $start = 0; } $filePath = "newhotpro.php"; if(isset($_REQUEST['request']) && $_REQUEST['request']=='addbiz') { //echo "select * from pro_hotprofrnds where user_id='$_SESSION[user_id]' and profile_id='$_REQUEST[profile_id]'"; $selfrnd=mysql_query("select * from pro_hotprofrnds where user_id='$_SESSION[user_id]' and profile_id='$_REQUEST[profile_id]'"); $selcn=mysql_num_rows($selfrnd); if($selcn>0) { header("location:myhotprofrnds.php?act=fail"); } else { $addbizclique=mysql_query("Insert into pro_hotprofrnds(user_id,link,profile_id,request_status,date_requested)values('".$_SESSION['user_id']."','".$_REQUEST['link']."','".$_REQUEST['profile_id']."',0,now())"); header("location:myhotprofrnds.php?act=success"); } } //$otherParams ="&profession=".$_REQUEST['profession']."&country=".$_REQUEST['country']."&state=".$_REQUEST['state']."&industry=".$_REQUEST['industry']."&specialization=".$_REQUEST['specialization']; //$Parameters ="profession=".$_REQUEST['profession']."&country=".$_REQUEST['country']."&state=".$_REQUEST['state']."&industry=".$_REQUEST['industry']."&specialization=".$_REQUEST['specialization']; //$_SESSION[otherParams]=$otherParams; //echo $_SESSION[otherParams];exit; ?> // echo "select * from pro_users where hideprofile=0 and".$condition;exit; $Totitems=mysql_query("select * from pro_users where upgrades='hotpro' and paid_upgrade_status='1' order by user_id desc"); $total=mysql_num_rows($Totitems); $allpages=$total/$limit; $totalpages=ceil($allpages);//echo $totalpages;exit; if($start>0) { $pagenumber=ceil($total/$start); } $sql_event="select * from pro_users where upgrades='hotpro' and paid_upgrade_status='1' order by user_id desc Limit $start,$limit"; $exec_query=mysql_query($sql_event); ?>