DST Posted October 12, 2010 Report Share Posted October 12, 2010 $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 Link to comment Share on other sites More sharing options...
sLIDe Posted October 12, 2010 Report Share Posted October 12, 2010 WHERE t1.mgroup = 3 Link to comment Share on other sites More sharing options...
DST Posted October 12, 2010 Author Report Share Posted October 12, 2010 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);'); Link to comment Share on other sites More sharing options...
X ID Posted October 12, 2010 Report Share Posted October 12, 2010 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 Link to comment Share on other sites More sharing options...
sLIDe Posted October 12, 2010 Report Share Posted October 12, 2010 $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'); Link to comment Share on other sites More sharing options...
DST Posted October 14, 2010 Author Report Share Posted October 14, 2010 varat taisiit ciet jau sen atrisinaju Link to comment Share on other sites More sharing options...
Recommended Posts