par
graffx » 10 janv. 2011, 22:53
Arf merci, en fait j' avais bien fait au debut, c' est juste que j' avais oublié un mysql_query!
Du coup, autre probleme, comment nommer ces variables dans un echo par la suite? Deja, voici ma requete :
<?php
$team2 = mysql_query("SELECT ibf_members.name,ibf_members.id,ibf_members.mgroup_others,ibf_member_extra.id,ibf_member_extra.avatar_location FROM ibf_members LEFT OUTER JOIN ibf_member_extra ON ibf_members.id = ibf_member_extra.id WHERE ibf_members.mgroup_others = ',7,' ");
while ($team = mysql_fetch_array($team2))
Pour le pseudo, si je fais $team['name'] ou $team['ibf_members.name'], ca fonctionne nickel.
Mais pour l' avatar, ni $team['avatar_location'] ni $team['ibf_member_extra.avatar_location'] ne fonctionne.
Si je fais un print_r, ca donne:
Coyote
Array ( [0] => Coyote [name] => Coyote [1] => 1 [id] => 1 [2] => ,7, [mgroup_others] => ,7, [3] => 1 [4] => av-1.png [avatar_location] => av-1.png )
Ska
Array ( [0] => Ska [name] => Ska [1] => 2 [id] => 2 [2] => ,7, [mgroup_others] => ,7, [3] => 2 [4] => [avatar_location] => )
SaD
Array ( [0] => SaD [name] => SaD [1] => 3 [id] => 3 [2] => ,7, [mgroup_others] => ,7, [3] => 3 [4] => av-3.jpg [avatar_location] => av-3.jpg )
Donc l' avatar est bien la. Mais je n' arrive pas a l' afficher.
Arf merci, en fait j' avais bien fait au debut, c' est juste que j' avais oublié un mysql_query!
Du coup, autre probleme, comment nommer ces variables dans un echo par la suite? Deja, voici ma requete :
[php] <?php
$team2 = mysql_query("SELECT ibf_members.name,ibf_members.id,ibf_members.mgroup_others,ibf_member_extra.id,ibf_member_extra.avatar_location FROM ibf_members LEFT OUTER JOIN ibf_member_extra ON ibf_members.id = ibf_member_extra.id WHERE ibf_members.mgroup_others = ',7,' ");
while ($team = mysql_fetch_array($team2)) [/php]
Pour le pseudo, si je fais $team['name'] ou $team['ibf_members.name'], ca fonctionne nickel.
Mais pour l' avatar, ni $team['avatar_location'] ni $team['ibf_member_extra.avatar_location'] ne fonctionne.
Si je fais un print_r, ca donne:
Coyote
Array ( [0] => Coyote [name] => Coyote [1] => 1 [id] => 1 [2] => ,7, [mgroup_others] => ,7, [3] => 1 [4] => av-1.png [avatar_location] => av-1.png )
Ska
Array ( [0] => Ska [name] => Ska [1] => 2 [id] => 2 [2] => ,7, [mgroup_others] => ,7, [3] => 2 [4] => [avatar_location] => )
SaD
Array ( [0] => SaD [name] => SaD [1] => 3 [id] => 3 [2] => ,7, [mgroup_others] => ,7, [3] => 3 [4] => av-3.jpg [avatar_location] => av-3.jpg )
Donc l' avatar est bien la. Mais je n' arrive pas a l' afficher.
