prepare('SELECT * FROM Reference_File WHERE Broker_Sender_ID = ?'); $stmt->bind_param('s', $user_n); $stmt->execute(); $results = $stmt->get_result(); //$row = $result->fetch_assoc(); $count =$result->num_rows; //$querys = "SELECT * FROM Reference_File Where Broker_Sender_ID ='".$user_n."'"; //$results = $mysqli->query($querys); while($rowz = $results->fetch_assoc()) { $Client_ID = $rowz["Client_ID"]; $query = "SELECT * FROM Client_Profile Where Client_ID ='".$Client_ID."' AND Deleted_Status ='0'"; $resultd = $mysqli->query($query); $Managers = $resultd->fetch_assoc(); ///////////////////////////////////// $Category_ID = $rowz["Category_Receiver_ID"]; $query = "SELECT * from Categories WHERE Category_ID='".$Category_ID."'"; $result = $mysqli->query($query); $Category_ID = $result->fetch_assoc(); ?>