Buna ziua am si eu o problema.
As dori sa leg cele 2 tabele iar apoi sa afisez informatii din cele 2 tabele, diferit. Mai exact:
tabelul 1 care se cheama gamehistory
teamid | matches | kills | damage | rating
tabelul 2 care se cheama teams
id | teamid | teamname | imgpath | created_at
Nu imi dau seama cum as putea lega cele 2 tabele astfel sa afisez kill-urile
sau damage-ul
din tabela 1 pentru echipa din tabela 2.
Mysql-ul arata asa:
$queryTeams = "
SELECT
pbt.*
FROM
pbmr_teams as pbt
";
$stmtQueryTeams = mysqli_stmt_init($connection);
if(!mysqli_stmt_prepare($stmtQueryTeams, $queryTeams)){
echo 'Statement failed';
} else {
mysqli_stmt_execute($stmtQueryTeams);
$resultQueryTeams = mysqli_stmt_get_result($stmtQueryTeams);
}
$teamsAssoc = mysqli_fetch_array($resultQueryTeams);
$teamsId = $teamsAssoc['id'];
$queryGameh = "
SELECT
pbh.*
FROM
pbmr_gamehistory as pbh,
pbmr_teams as pbt
WHERE
pbh.teamid = pbt.teamid AND
pbt.teamid = '.$teamsId.'
";
$stmtGameh = mysqli_stmt_init($connection);
if(!mysqli_stmt_prepare($stmtGameh, $queryGameh)){
echo 'Statement failed';
} else {
mysqli_stmt_execute($stmtGameh);
$resultGameh = mysqli_stmt_get_result($stmtGameh);
}
As dori sa le afisez aici.
Exemplu inainte de numele echipei sa iau imgpath
din tabela 2
si datele corespunzatoare tabelei 1
.
Multumesc!