Registered participants

[insert_php] $db_server = “mysql7.unoeuro.com”;
$db_username = “vushf_dk”;
$database = “vushf_dk_db”;
$db_password = “2014EdrVhf”;

$conn = new mysqli($db_server, $db_username, $db_password, $database);

$result = $conn->query(“SELECT DISTINCT field_value FROM vushfwp_cf7dbplugin_submits where field_name = ‘your-call’ ORDER BY field_value”);

$i = 0;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
while ($row=$result->fetch_array(MYSQLI_ASSOC) )
{
$Call = strtoupper($row[‘field_value’]);
echo ‘

‘;
echo ‘

‘;
$i++;

}
echo ‘

CALLSIGN
‘; echo $Call; echo ‘

‘;
echo ‘

Number of participants ‘.$i.’

‘;
[/insert_php]