Im trying to insert an array into a SELECT WHERE id = array() and im trying to show the results in a table,i can get one row of data, the first teams name,wins,and losses, but the remaining 4 teams do not appear.Im trying to show all teams where there id's are equal to the array.
$tournament = mysql_query("SELECT * FROM `tournaments` WHERE `id` = ".((int)$slug[1])." LIMIT 1");
if (mysql_num_rows($tournament) > 0) {
$tournament = mysql_fetch_assoc($tournament);
}
//array is equal to 273,287,234,423,124
$teamx = array();
$teamx[] = $tournament['teams'];
$tteams = mysql_query("SELECT * FROM `teams` WHERE `id` IN (" . implode(',', array_map('intval', $teamx)) . ") LIMIT 128");
if (mysql_num_rows($tteams) > 0) {
$tteams = mysql_fetch_assoc($tteams);
$template['TOURNAMENTTEAMS'] .= '<tr><td style="text-align: center;"><strong>' .$tteams['name']. '</td><td style="text-align: center;">' .$tteams['wins']. '</td><td style="text-align: center;">' .$tteams['losses']. '</td></tr>';
}else{
$template['TOURNAMENTTEAMS'] .= '<tr><td style="text-align: center;"><strong>No eligible teams.</td><td style="text-align: center;"></td><td></td></tr>';
}`