PHP - Can't Get Code To Work :-( For Printing List Of Countries

Dear Friends,

I am alot before doing the mixed content of php and HTML in single variable in PHP.. 

I could not get the data even though there is not SYNTAX error.. 

please look my code and advise

$htmlcontent .="
<tr>
	<td colspan=\"8\">".$details."></td>
</tr>";
	for($k=0;$k<count($reg_years[$details]);$k++) {
			$year =  (int)($reg_years[$details][$k]);
			$singlecount[$year] = array_filter($result[$details],function($details1) use ($year){	
			return ($details1['reg_year'] == $year && $details1['bench_type'] == 1);
		});
		$divisioncount[$year] = array_filter($result[$details],function($details2) use ($year){
			return ($details2['reg_year'] == $year && $details2['bench_type'] == 2);
		});
		$fullcount[$year] = array_filter($result[$details],function($details3) use ($year){
			return ($details3['reg_year'] == $year && $details3['bench_type'] >= 3);
		}); 
		$rpcount[$year] = array_filter($result[$details],function($rp) use ($year){	
			return ($rp['reg_year'] == $year && $rp['bench_type'] == 'RP');
		}); 
		$mjccount[$year] = array_filter($result[$details],function($mjc) use ($year){	
			return ($mjc['reg_year'] == $year && $mjc['bench_type'] == 'MJC');
		}); 
		$cocount[$year] = array_filter($result[$details],function($co) use ($year){	
			return ($co['reg_year'] == $year && $co['bench_type'] == 'X');
		}); 
		$total = 0;
		$total = (int)(count($singlecount[$year])+count($divisioncount[$year])+count($fullcount[$year])+count($rpcount[$year])+count($mjccount[$year])+count($cocount[$year]));
		
			
		
		$htmlcontent .="
		<tr>
			<td>".$year."</td>
			<td align=\"center\"> 
			      if(count($singlecount[$year])>0) {
					echo (count($singlecount[$year]));
				  }
				  else {
					echo "-";
				  }	
					
			</td>
			<td align=\"center\">
			      if(count($divisioncount[$year])>0) {
					".count($divisioncount[$year])."
				  } else {
					"-"
				  }	
				</td>
				<td align=\"center\">
if (count($fullcount[$year]) > 0)
{
    echo (count($fullcount[$year]));
}
else
{
    echo "-";
} </td > < td align =\"center\">
   					if(count($rpcount[$year])>0)  { 
   					 echo (count($rpcount[$year]));
					
            		 } else { echo " - "; }  
            	</td>
							
				<td align=\"center\">
				 if(count($mjccount[$year])>0)  { 
   					 echo (count($mjccount[$year])); 
				  } else { echo " - "; }  
                </td>
							
			<td align=\"center\"> 
					 if(count($cocount[$year])>0)  { 
   					 echo (count($cocount[$year])); 
			
            		 } else { echo " - "; }  
			</td>
			<td align=\"center\"> 
					
   					echo $total; 
            		
			</td> 			
		</tr>";

}
}

$htmlcontent .= "</tbody></table>";

$mpdf = new \Mpdf\Mpdf();
$mpdf->WriteHTML($htmlcontent);
$mpdf->Output();

Waiting for FAST reply

Thanks

Anes

I have 64 rows of players and want each User to be able to choose to bookmark an player, as well as unbookmark it too.

I have a bookmark table set up, and each time a User decides to bookmark(+) or unbookmark(-) an player a row is created in the data table.   (Matching the player ID and User ID) That's working fine.  

A query reads the most recent row for each player to determine if there is a + or - button next to each player.  Testing the query and adding some dummy data, that part of it works too.  However, the issue is the initial state, which I want to be a +.  Once I go live, the table will be empty, nothing for the query to return/produce.

How do I create an initial state of a + with no rows and have it not used or swapped out when Users start clicking + or -?

  $query = "SELECT b.id, bookmark,playerID,userID,p.id 
                FROM a_player_bookmark b
                LEFT JOIN a_players p
                ON '". $id ."' = playerID
                WHERE userID = '". $userID ."'&&'". $id ."' = playerID
                ORDER BY b.id desc
                LIMIT 1
                ";

    $results = mysqli_query($con,$query);
    echo mysqli_error($con);
    while($row = mysqli_fetch_assoc($results)) {    

    echo $row['bookmark'];

        if($row['bookmark'] == 0) {
            echo '-'; // this is where a form goes to remove a bookmark
        }       
        else {
            echo '+'; // this is where a form goes to add a bookmark
        }

    }   

I tried to get it with CASE, but I don't think that's the right path.  I also looked at UNION.  I was able to get it to produce an initial state of +, but it still printed the already made up sample data too (so I have three instances of ++ or +-).

 (Players 2, 4 and 4)

Here is the what the UNION query looked like:

	$query = "(SELECT b.id, bookmark,playerID,userID,p.id 
				FROM a_player_bookmark b
				LEFT JOIN a_players p
				ON '". $id ."' = playerID
				
				WHERE userID = '". $userID ."'&&'". $id ."' = playerID
				ORDER BY b.id desc
				LIMIT 1)
			UNION
				(SELECT b.id, bookmark,playerID,userID,p.id 
				FROM a_player_bookmark b
				LEFT JOIN a_players p
				ON '". $id ."' = playerID
				
				WHERE userID = '". $userID ."'
				ORDER BY p.id desc
				LIMIT 1) 
				";