willpower Posted July 31, 2006 Share Posted July 31, 2006 Well sort off.I establish the date. I then want to go to a db containing start signs and find out which is the current star sign based on the date. I then want to list all start signs starting with the most current. ie Records retrieved could be in this order567891011121234I have lost the plot on this...can anyone help me to do this???Thanks in advancewill Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/ Share on other sites More sharing options...
BillyBoB Posted July 31, 2006 Share Posted July 31, 2006 do you want them to display ordered by lastest or starting from 5 then to the end and then 1-4 ??? Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66684 Share on other sites More sharing options...
ryanlwh Posted July 31, 2006 Share Posted July 31, 2006 i think he wants the current month, then ascending order until december, then jan to last month, as in those horoscope articles.one question for willpower: how do you store the star signs dates? Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66692 Share on other sites More sharing options...
willpower Posted July 31, 2006 Author Share Posted July 31, 2006 hi i have a startd and startm field - and a endd and endmie startd = 22startm = 07endd = 23endm = 08And yes I want them to display in chronological order. so if capricorn was the current sign I want to display the ALL but starting with capricorn...or if it were gemini the same etc.Hope that makes sense Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66705 Share on other sites More sharing options...
ryanlwh Posted July 31, 2006 Share Posted July 31, 2006 hmm[code]SELECT * FROM signs ORDER BY startm*100+startd>=MONTH()*100+DAY() DESC,startm,startd[/code] Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66723 Share on other sites More sharing options...
willpower Posted July 31, 2006 Author Share Posted July 31, 2006 that gives me a sytax error Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66728 Share on other sites More sharing options...
willpower Posted July 31, 2006 Author Share Posted July 31, 2006 ps could you explain what that should have done so i can try and amend it also?Thanks Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66731 Share on other sites More sharing options...
ryanlwh Posted July 31, 2006 Share Posted July 31, 2006 sorry, i forgot something in the MONTH and DAY[code]SELECT * FROM signs ORDER BY startm*100+startd>=MONTH(NOW())*100+DAY(NOW()) DESC,startm,startd[/code]basically startm*100+startd>=MONTH(NOW())*100+DAY(NOW()) is to figure out whether or not today is on or after the start of a starsign (1 if on or after, 0 if before). We use DESC because you want 0 to appear later (the months before this sign). then, after the first sort, we proceed to do it chronologically with startm and startd. Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66736 Share on other sites More sharing options...
willpower Posted July 31, 2006 Author Share Posted July 31, 2006 oh....so close. I wish i understood the query.I now get the order i want but the starting record is out by one...i get virgo rather than libra....by the way...i hate horoscopes.any ideas?Will Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66751 Share on other sites More sharing options...
ryanlwh Posted July 31, 2006 Share Posted July 31, 2006 damn, i make so many mistakes today :)[code]SELECT * FROM signs ORDER BY MONTH(NOW())*100+DAY(NOW()) >= startm*100+startd DESC,startm,startd[/code] Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66757 Share on other sites More sharing options...
willpower Posted July 31, 2006 Author Share Posted July 31, 2006 lol. Thanks so much for your help....its now worse and starts with some other star sign ;)I bow to your greatness....regardless of how many mistakes you make!!!Will Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66764 Share on other sites More sharing options...
willpower Posted August 1, 2006 Author Share Posted August 1, 2006 What can i say....THANK YOU Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66773 Share on other sites More sharing options...
ryanlwh Posted August 1, 2006 Share Posted August 1, 2006 [code]SELECT * FROM signs ORDER BY endm*100+endd>=MONTH(NOW())*100+DAY(NOW()) DESC,startm,startd[/code] Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-66777 Share on other sites More sharing options...
willpower Posted August 14, 2006 Author Share Posted August 14, 2006 After all this time...i have noticed an issue...Capricorn comes last in the list rather than between sag and aquarius. Current list readsleo: correctVirgo : correctLibra: correctScorpio :correctSagitaruis: correctAquarius : correct in that it has looped back to the start but capricorn omiited Pisces: correctAries : correctTaurus : correctGemini : corectCancer : correctCapricorn : god damn itAny clues?PS is it to do with the fact that capricorn starts in month 12 and ends in month 1 Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-74262 Share on other sites More sharing options...
willpower Posted August 14, 2006 Author Share Posted August 14, 2006 bump Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-74395 Share on other sites More sharing options...
willpower Posted August 16, 2006 Author Share Posted August 16, 2006 double bump Link to comment https://forums.phpfreaks.com/topic/16150-select-starting-from-record-5-then-back-to-record-1/#findComment-75443 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.