Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [Wychwood] MySQL Query ORDER BY giving weird results

Jun 5, 2008, 8:39 PM
dan
Enthusiast (760 posts)
dan's avatar
Jun 5, 2008, 8:39 PM
Views: 24517
Shortcut
Quote Reply
Re: [Wychwood] MySQL Query ORDER BY giving weird results In reply to
Let's play nice =)

Perl hashes have no internal ordering. By design, the results are returned in a random order. One solution may be Tie::IxHash. Another solution is to retrieve and map the original hash keys to an array, and use that array to iterate the hash.

----
Cheers,

Dan
Founder and CEO

LionsGate Creative
GoodPassRobot
Magelln
Subject Author Views Date
Thread MySQL Query ORDER BY giving weird results EZFrag 25013 Jun 4, 2008, 7:48 AM
Thread Re: [EZFrag] MySQL Query ORDER BY giving weird results 		Andy 24626 Jun 4, 2008, 8:07 AM
Thread Re: [Andy] MySQL Query ORDER BY giving weird results 		EZFrag 24585 Jun 4, 2008, 11:37 PM
Post Re: [EZFrag] MySQL Query ORDER BY giving weird results 		Andy 24431 Jun 4, 2008, 11:57 PM
Thread Re: [EZFrag] MySQL Query ORDER BY giving weird results 		EZFrag 24526 Jun 5, 2008, 12:23 AM
Thread Re: [EZFrag] MySQL Query ORDER BY giving weird results 		Andy 24572 Jun 5, 2008, 1:13 AM
Thread Re: [Andy] MySQL Query ORDER BY giving weird results 		EZFrag 24587 Jun 5, 2008, 2:34 AM
Thread Re: [EZFrag] MySQL Query ORDER BY giving weird results 		Andy 24596 Jun 5, 2008, 2:39 AM
Thread Re: [Wychwood] MySQL Query ORDER BY giving weird results 		dan 24517 Jun 5, 2008, 8:39 PM
Thread Re: [dan] MySQL Query ORDER BY giving weird results 		Wychwood 24514 Jun 6, 2008, 2:27 AM
Thread Re: [Wychwood] MySQL Query ORDER BY giving weird results 		SandraR 24476 Jun 9, 2008, 11:13 AM
Post Re: [SandraR] MySQL Query ORDER BY giving weird results 		Wychwood 24384 Jun 10, 2008, 2:26 AM
Post Re: [EZFrag] MySQL Query ORDER BY giving weird results 		Wychwood 24431 Jun 4, 2008, 11:10 AM