<?php
 $DBhost = 'localhost';
  $DBuser = 'root';
  $DBpass = '';
  $DBname = 'fts_forum';

  $DBcon = new MySQLi($DBhost,$DBuser,$DBpass,$DBname);

     if ($DBcon->connect_errno) {
         die("ERROR : -> ".$DBcon->connect_error);
     }

    $conn = new PDO("mysql:host=$DBhost; dbname=$DBname", $DBuser, $DBpass);
    $conn->exec("SET CHARACTER SET utf8");      // Sets encoding UTF-8
    try {

    $result = $conn->prepare("SELECT * FROM core_members WHERE `member_group_id` = 4 ");
    $result->execute();

	$coleader = $conn->prepare("SELECT * FROM core_members WHERE `member_group_id` = 8 ");
    $coleader->execute();

	$developer = $conn->prepare("SELECT * FROM core_members WHERE `member_group_id` = 10 ");
    $developer->execute();

	$member = $conn->prepare("SELECT * FROM core_members WHERE `member_group_id` = 7 ORDER BY FIELD(member_title, 'Developer', 'DM Clanwar Manager', 'DM Clanwar assistant Manager','Discord Server Manager','Member')");
    $member ->execute();
	  $trial = $conn->prepare("SELECT * FROM core_members WHERE `member_group_id` = 9 ");
    $trial ->execute();
} catch (PDOException $e) {
    echo $e->getMessage();
}
?>