<?php

// select distinct id
// from users
// where id in ( select id_user_2 as id from user_likes where (id_user_1 = 11) )
// and id in ( select id_user_1 as id from user_likes where (id_user_2 = 11)
// );

// eerst username ophalen

$username = $_GET['username'];

//DATABSE DETAILS//
require 'db.php';

$db_handle = mysql_connect($server, $dbuser, $password_db);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

    // user id ophalen

    $user = mysql_query("SELECT * FROM users where `username` = '$username' ");
    $user_row = mysql_fetch_assoc($user);

    $user_id = $user_row['id'];

    // Kijken naar matches
    $query = mysql_query("SELECT distinct id FROM users WHERE id in ( select `id_user_2` as id from user_likes where(`id_user_1` = '$user_id') )");

    if(mysql_num_rows($query) > 0) {

        while($row = mysql_fetch_array($query)) {

                $id = $row['id'];

                $liked_username_query = mysql_query("SELECT * FROM users where `id` = '$id' ");

                $liked_user_row = mysql_fetch_assoc($liked_username_query);

                echo '"' .$liked_user_row['username']. '", ';

        }

    }
    else {
        echo 'Je hebt geen matches!';
    }



}

else {
    print "Database NOT Found.";
    mysql_close($db_handle);
}


?>