Ipb Selects.

[DST]

 $result = mysql_query('select t1.id,t1.members_display_name,t2.avatar_location, t2.avatar_type from '.$INFO['sql_tbl_prefix'].'members t1  join '.$INFO['sql_tbl_prefix'].'member_extra t2 on (t1.id = t2.id);');

ka sitam querijam var pielikt pie mebers

WHERE mgroup = 3

[sLIDe]

WHERE t1.mgroup = 3

[DST]

nesanak.

ja tu biji domajis sita

 $result = mysql_query('select t1.id,t1.members_display_name,t2.avatar_location, t2.avatar_type from '.$INFO['sql_tbl_prefix'].'members t1 WHERE t1.mgroup = 3  join '.$INFO['sql_tbl_prefix'].'member_extra t2 on (t1.id = t2.id);');

[X ID]

Baigi interesantu linku atradu. Nosaukums arī dīvains - "manuālis". Varbūt tev arī liksies tik pat interesants (lai gan šaubos). Ņem palasi: http://dev.mysql.com/doc/refman/5.0/en/select.html

[sLIDe]

$result = mysql_query('SELECT t1.id,t1.members_display_name,t2.avatar_location, t2.avatar_type FROM '.$INFO['sql_tbl_prefix'].'members t1 LEFT JOIN '.$INFO['sql_tbl_prefix'].'member_extra t2 ON (t1.id = t2.id) WHERE t1.mgroup = 3');

[DST]

varat taisiit ciet jau sen atrisinaju