Aquí expongo:
Tengo una página de prueba que me debería mostrar el contenido correcto de cada valor dicho código es:
Código PHP:
<? require('***') ?>
<?php
echo '<b>Aldebaran(Neuschwanstein)</b>: <i><font color="green">'.$casti1name.'</font></i> | ';
echo '<b>Prontera(Fadhgridh)</b>: <i><font color="green">'.$casti2name.'</font></i> | ';
echo '<b>Payon(Sacred Altar)</b>: <i><font color="green">'.$casti3name.'</font></i>. ';
print_r ($casti1);
print_r ($casti2);
print_r ($casti3);
print_r ($casti1name);
print_r ($casti2name);
print_r ($casti3name);
?>
Código PHP:
$casti1 = array(0 => mysql_query("SELECT guild_id FROM guild_castle WHERE guild_id = 0"));
$casti1name = array(0 => mysql_query("SELECT name FROM guild WHERE guild_id = '".$casti1[0]."'"));
$casti2 = array(0 => mysql_query("SELECT guild_id FROM guild_castle WHERE guild_id = 13"));
$casti2name = array(0 => mysql_query("SELECT name FROM guild WHERE guild_id ='".$casti2[0]."'"));
$casti3 = array(0 => mysql_query("SELECT guild_id FROM guild_castle WHERE guild_id = 17"));
$casti3name = array(0 => mysql_query("SELECT name FROM guild WHERE guild_id = '".$casti3[0]."'"));
Es decir esto es lo que me muestra:
Cita:
Gracias de ante mano por vuestra ayuda. ]Aldebaran(Neuschwanstein): Array | Prontera(Fadhgridh): Array | Payon(Sacred Altar): Array. Array ( [0] => Resource id #8 ) Array ( [0] => Resource id #10 ) Array ( [0] => Resource id #12 ) Array ( [0] => Resource id #9 ) Array ( [0] => Resource id #11 ) Array ( [0] => Resource id #13 )