Hola amigos, hice una consulta en donde intento recuperar valores desde 2 tablas diferentes de una base MySQL.
Pero, no me devuelve resultados y no logro encontrar el error.
Podrían ayudarme? Gracias por anticipado
Código PHP:
$result5 = mysql_query("SELECT * FROM players_historial,players_division WHERE players_historial.Id_division=players_division.Id_division AND players_historial.Id_jugador=$jugador ORDER BY players_historial.desde ASC", $db);
while ($myrow5 = mysql_fetch_array($result5)) {
$codigo = $myrow5["players_historial.Id_historial"];
$la_division = $myrow5["players_division.desc_division"];
$el_club = $myrow5["players_historial.club"];
$comienzo = $myrow5["players_historial.desde"];
$final = $myrow5["players_historial.hasta"];
print ("<tr>
<td bgcolor='#CCCC99'><font face='Trebuchet MS' size='2'>$codigo</font></td>
<td bgcolor='#FFFFCC'><font face='Trebuchet MS' size='2' color='#000000'>club</font></td>
<td bgcolor='#FFFFCC'><font face='Trebuchet MS' size='2'>$la_division</font></td>
<td bgcolor='#FFFFCC'>
<div align='center'><font face='Trebuchet MS'><font face='Trebuchet MS'><font size='2'>$comienzo</font></font></font></div>
</td>
<td bgcolor='#FFFFCC'>
<div align='center'><font face='Trebuchet MS' size='2'>$final</font></div>
</td>
<td bgcolor='#CCCC99'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>Borrar</font></div>
</td>
<td bgcolor='#CCCC99'>
<div align='center'><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>Modificar</font></div>
</td>
</tr>");
}
Saludos
Sergio