Code: Select all
$query = "SELECT t1.room_id as Room, t2.username as Host, t1.w_seat as White, t1.b_seat as Black, t1.vrijeme as Time, t1.povecanje as Increment FROM tabla as t1, player as t2 WHERE t1.host_id = t2.player_id";Code: Select all
$query = "SELECT t1.room_id as Room, t2.username as Host, t2.username as White, t2.b_seat as Black, t1.vrijeme as Time, t1.povecanje as Increment FROM tabla as t1, player as t2 WHERE t1.host_id = t2.player_id";