eT` Posted February 14, 2010 Report Share Posted February 14, 2010 Tātad vai ir iespēja SELECT kvērijā pie ORDER By uzlikt tiem pēc kā kārto tādas kā prioritātes? Piemēram no sākuma visus, kam pinned='1', tad visus pārējos pēc lastpost DESC ? Quote Link to comment Share on other sites More sharing options...
eT` Posted February 14, 2010 Author Report Share Posted February 14, 2010 atrisināju. $sql5 = mysql_query("SELECT * FROM forums_topics WHERE fid='$fid' ORDER BY pinned DESC,lastpost DESC"); Quote Link to comment Share on other sites More sharing options...
waplet Posted February 14, 2010 Report Share Posted February 14, 2010 :D Quote Link to comment Share on other sites More sharing options...
endrju Posted February 15, 2010 Report Share Posted February 15, 2010 eT, kad būs pieejams/publicēsi kodu? Quote Link to comment Share on other sites More sharing options...
waplet Posted February 15, 2010 Report Share Posted February 15, 2010 ir jau :D http://php.lv/f/topic/15677-select-order/page__view__findpost__p__121034 Quote Link to comment Share on other sites More sharing options...
EdgarsK Posted February 15, 2010 Report Share Posted February 15, 2010 šitāds jau kautkad bija redzēts :/ Quote Link to comment Share on other sites More sharing options...
endrju Posted February 15, 2010 Report Share Posted February 15, 2010 ir jau :D http://php.lv/f/topic/15677-select-order/page__view__findpost__p__121034 Ni, ni. Es biju domājis to pašu forumu. Cik saprotu, viņš tagad cepj savu forumu, ne tā? 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.