Mam takie zapytanie:
<?php $query = "SELECT u.id id, e.id_clan id_clan, e.clan_active clan_active, c.name clan_n
ame, c.id_clan_admin id_clan_admin, c.active clan_activated FROM ".$GLOBALS['guest_tbl']." u LEFT JOIN ".$GLOBALS['guest_ext_tbl']." e on (u.id = e.users_id) e LEFT JOIN ".$GLOBALS['clanwar_clans_tbl']." c on (e.id_clan = c.id) WHERE u.nick='".$_SESSION['gnick']."'"; ?>
gdzie:
guest_tbl = ("id", "nick", "pass"...itp)
guest_ext_tbl = ("id", "users_id", "id_clan", "clan_activate")
clanwar_clans_tbl = ("id", "active", "id_clan_admin", "name", "tag"...itp)
moje pytanie brzmi czy dobrze jest napisane to zapytanie ? Bo kiedy zapisuje plik i odpalam to jest blad "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/virtual/...../plik.php on line 18".
Prosze o pomoc.
Z gory dzieki.