GeRik Posted December 3, 2009 Report Share Posted December 3, 2009 kads sheit var iebast WHERE mgroup=$admin $result = mysql_query("SELECT t1.id,t1.members_display_name,t2.bilde FROM ".$INFO['sql_tbl_prefix']."members t1 JOIN ".$INFO['sql_tbl_prefix']."members t2 ON (t1.id = t2.id) LIMIT $start, $number_in_page;"); Liku visadi bet vienalga nesanak mekleju ka pareizi jaliek jair visi tie t1 bet vienalga nekadigi nesanaca Quote Link to comment Share on other sites More sharing options...
waplet Posted December 3, 2009 Report Share Posted December 3, 2009 ON (t1.id = t2.id) AND (mgroup = $admin) Quote Link to comment Share on other sites More sharing options...
marcis Posted December 3, 2009 Report Share Posted December 3, 2009 waplet, nebūs pareizi. Un vispār, kāpēc jājoino viena tabula un tā pati tabula pie tām pašām kolonām? Quote Link to comment Share on other sites More sharing options...
GeRik Posted December 3, 2009 Author Report Share Posted December 3, 2009 waplet, nebūs pareizi. Un vispār, kāpēc jājoino viena tabula un tā pati tabula pie tām pašām kolonām? Pa shito nebiju aizdomajies Paldies :) var slegt ciet Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.