eT` Posted February 14, 2010 Report 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
eT` Posted February 14, 2010 Author Report Posted February 14, 2010 atrisināju. $sql5 = mysql_query("SELECT * FROM forums_topics WHERE fid='$fid' ORDER BY pinned DESC,lastpost DESC"); Quote
endrju Posted February 15, 2010 Report Posted February 15, 2010 eT, kad būs pieejams/publicēsi kodu? Quote
waplet Posted February 15, 2010 Report Posted February 15, 2010 ir jau :D http://php.lv/f/topic/15677-select-order/page__view__findpost__p__121034 Quote
EdgarsK Posted February 15, 2010 Report Posted February 15, 2010 šitāds jau kautkad bija redzēts :/ Quote
endrju Posted February 15, 2010 Report 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
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.