ordering search results

am 17.07.2009 17:06:50 von PJ

Can't find anything on the web that deals with my problem(s).
I have to display thousands of book listings by title, sub_title with 10
books per page. The php/mysql code works fine - except:
ASC or DESC does not change one iota.
I have checked by commandline and find that it is not working at all how
I would expect.
From commandline, using just title and switching between ASC & DESC give
totally different results rather than displaying the same data in
reverse order.
The display is, as mentioned above, 10 books per output page: so, from
what appears to me, the ordering seems to be done on the entire db & not
just on the search results (this is basically from a SELECT statement).
Furthermore, not all the data is in 1 table; authors, categories &
publishers are in separate tables because of 1 to many & many to 1
relationships.
Still another problem is the use of a number of foreign languages which
have those strange accent on many letters that do not order very well.
Now, that I have spewed out my problems, would it be possible that there
is someone out there who could suggest how to go about figuring this out?
Thanks in advance.

--
HervÃ© Kempf: "Pour sauver la planÃ¨te, sortez du capitalisme."
------------------------------------------------------------ -
Phil Jourdan --- pj@ptahhotep.com
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: ordering search results

am 17.07.2009 21:58:40 von Darryle steplight

You might have to change the collation you are currently using to one
that best match the language of those weird accents you are referring
too. That's part of the reason you may be getting unexpected results
with your ORDER BY statement. Also, can you show us your select
statements?

On Fri, Jul 17, 2009 at 11:06 AM, PJ wrote:
> Can't find anything on the web that deals with my problem(s).
> I have to display thousands of book listings by title, sub_title with 10
> books per page. The php/mysql code works fine - except:
> ASC or DESC does not change one iota.
> I have checked by commandline and find that it is not working at all how
> I would expect.
> From commandline, using just title and switching between ASC & DESC give
> totally different results rather than displaying the same data in
> reverse order.
> The display is, as mentioned above, 10 books per output page: so, from
> what appears to me, the ordering seems to be done on the entire db & not
> just on the search results (this is basically from a SELECT statement).
> Furthermore, not all the data is in 1 table; authors, categories &
> publishers are in separate tables because of 1 to many & many to 1
> relationships.
> Still another problem is the use of a number of foreign languages which
> have those strange accent on many letters that do not order very well.
> Now, that I have spewed out my problems, would it be possible that there
> is someone out there who could suggest how to go about figuring this out?
> Thanks in advance.
>
> --
> Herv=E9 Kempf: "Pour sauver la plan=E8te, sortez du capitalisme."
> ------------------------------------------------------------ -
> Phil Jourdan --- pj@ptahhotep.com
> =A0 http://www.ptahhotep.com
> =A0 http://www.chiccantine.com/andypantry.php
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Ddsteplight@gm=
ail.com
>
>

--=20
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: ordering search results

am 17.07.2009 22:25:05 von PJ

Here's the query:
"SELECT * FROM book ORDER BY $sort $dir LIMIT $offset, $records_per_page";
$sort == 'title, sub_title'; $dir==ASC (or DESC); $offset== (any
multiple of 10); $records_per_page== 10;
I could let the user change these, but I decided it is simpler to keep
it at 10 books/page. Only the $dir is user settable.
The character set is utf8-general; (I just went through some
self-torture changing all those foreign curlicues to :&cutesy_stuff;
fortunately, the mysql replace() function helped - but six languages
have quite a few weird accents.
The title field can be fairly long - 182 chars; sub_title is 128, but it
looks like I have to lengthen that too; found some truncated inputs.

Another problem is the Thes - how do you exclude them
from the ordering.

Also: one output with just title for field returned a series of The
Art.., The Birds..., The Birth...etc. in ASC; whereas DESC returned:
Boats, Black Cumin, Birds of..., Biological..., Bioarchaeology..,
Avaris... etc.

Darryle Steplight wrote:
> You might have to change the collation you are currently using to one
> that best match the language of those weird accents you are referring
> too. That's part of the reason you may be getting unexpected results
> with your ORDER BY statement. Also, can you show us your select
> statements?
>
> On Fri, Jul 17, 2009 at 11:06 AM, PJ wrote:
>
>> Can't find anything on the web that deals with my problem(s).
>> I have to display thousands of book listings by title, sub_title with 10
>> books per page. The php/mysql code works fine - except:
>> ASC or DESC does not change one iota.
>> I have checked by commandline and find that it is not working at all how
>> I would expect.
>> From commandline, using just title and switching between ASC & DESC give
>> totally different results rather than displaying the same data in
>> reverse order.
>> The display is, as mentioned above, 10 books per output page: so, from
>> what appears to me, the ordering seems to be done on the entire db & not
>> just on the search results (this is basically from a SELECT statement).
>> Furthermore, not all the data is in 1 table; authors, categories &
>> publishers are in separate tables because of 1 to many & many to 1
>> relationships.
>> Still another problem is the use of a number of foreign languages which
>> have those strange accent on many letters that do not order very well.
>> Now, that I have spewed out my problems, would it be possible that there
>> is someone out there who could suggest how to go about figuring this out?
>> Thanks in advance.
>>
>> --
>> Hervï¿½ Kempf: "Pour sauver la planï¿½te, sortez du capitalisme."
>> ------------------------------------------------------------ -
>> Phil Jourdan --- pj@ptahhotep.com
>> ï¿½ http://www.ptahhotep.com
>> ï¿½ http://www.chiccantine.com/andypantry.php
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: ï¿½ ï¿½http://lists.mysql.com/mysql?unsub=dsteplight@gmail.com
>>

--
HervÃ© Kempf: "Pour sauver la planÃ¨te, sortez du capitalisme."
------------------------------------------------------------ -
Phil Jourdan --- pj@ptahhotep.com
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: ordering search results

am 17.07.2009 22:57:00 von Gavin Towey

RnJvbSB5b3VyIGRlc2NyaXB0aW9uIG9mIHlvdXIgcHJvYmxlbSwgaXQncyB2 ZXJ5IGRpZmZpY3Vs
dCB0byB1bmRlcnN0YW5kIHdoYXQgeW91J3JlIGRvaW5nIGFuZCB3aGF0IHJl c3VsdHMgeW91J3Jl
IHRyeWluZyB0byBnZXQuDQoNCk1ha2luZyBzb21lIGFzc3VtdGlvbnMsIEkg dGhpbmsgeW91IG1p
Z2h0IG5lZWQgdG8gdXNlIGEgdGVjaG5pcXVlIGRlc2NyaWJlZCBpbiB0aGlz IGxpbmsgdG8gZ2V0
IHRoZSByZXN1bHRzIHlvdSB3YW50OiBodHRwOi8vamFuLmtuZXNjaGtlLmRl L3Byb2plY3RzL215
c3FsL2dyb3Vwd2lzZS1tYXgNCg0KT3RoZXJ3aXNlLCBmb3IgYmV0dGVyIGhl bHA6DQoxKSBTaG93
IHVzIHRoZSBleGFjdCBxdWVyeSB5b3UgYXJlIGRvaW5nLCBhbmQgdGhlIHN0 cnVjdHVyZSBvZiB0
aGUgdGFibGVzLg0KMikgU2hvdyBhIHNtYWxsIHNhbXBsZSBkYXRhIHNldCBp ZiBwb3NzaWJsZQ0K
MykgU2hvdyB3aGF0IHRoZSByZXN1bHQgc2V0IHlvdSB3YW50IHdvdWxkIGxv b2sgbGlrZS4NCg0K
UmVnYXJkcywNCkdhdmluIFRvd2V5DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2Fn ZS0tLS0tDQpGcm9t
OiBQSiBbbWFpbHRvOmFmLmdvdXJtZXRAdmlkZW90cm9uLmNhXQ0KU2VudDog RnJpZGF5LCBKdWx5
IDE3LCAyMDA5IDg6MDcgQU0NClRvOiBNeVNxbA0KU3ViamVjdDogb3JkZXJp bmcgc2VhcmNoIHJl
c3VsdHMNCg0KQ2FuJ3QgZmluZCBhbnl0aGluZyBvbiB0aGUgd2ViIHRoYXQg ZGVhbHMgd2l0aCBt
eSBwcm9ibGVtKHMpLg0KSSBoYXZlIHRvIGRpc3BsYXkgdGhvdXNhbmRzIG9m IGJvb2sgbGlzdGlu
Z3MgYnkgdGl0bGUsIHN1Yl90aXRsZSB3aXRoIDEwDQpib29rcyBwZXIgcGFn ZS4gVGhlIHBocC9t
eXNxbCBjb2RlIHdvcmtzIGZpbmUgLSBleGNlcHQ6DQpBU0Mgb3IgREVTQyBk b2VzIG5vdCBjaGFu
Z2Ugb25lIGlvdGEuDQpJIGhhdmUgY2hlY2tlZCBieSBjb21tYW5kbGluZSBh bmQgZmluZCB0aGF0
IGl0IGlzIG5vdCB3b3JraW5nIGF0IGFsbCBob3cNCkkgd291bGQgZXhwZWN0 Lg0KRnJvbSBjb21t
YW5kbGluZSwgdXNpbmcganVzdCB0aXRsZSBhbmQgc3dpdGNoaW5nIGJldHdl ZW4gQVNDICYgREVT
QyBnaXZlDQp0b3RhbGx5IGRpZmZlcmVudCByZXN1bHRzIHJhdGhlciB0aGFu IGRpc3BsYXlpbmcg
dGhlIHNhbWUgZGF0YSBpbg0KcmV2ZXJzZSBvcmRlci4NClRoZSBkaXNwbGF5 IGlzLCBhcyBtZW50
aW9uZWQgYWJvdmUsIDEwIGJvb2tzIHBlciBvdXRwdXQgcGFnZTogc28sIGZy b20NCndoYXQgYXBw
ZWFycyB0byBtZSwgdGhlIG9yZGVyaW5nIHNlZW1zIHRvIGJlIGRvbmUgb24g dGhlIGVudGlyZSBk
YiAmIG5vdA0KanVzdCBvbiB0aGUgc2VhcmNoIHJlc3VsdHMgKHRoaXMgaXMg YmFzaWNhbGx5IGZy
b20gYSBTRUxFQ1Qgc3RhdGVtZW50KS4NCkZ1cnRoZXJtb3JlLCBub3QgYWxs IHRoZSBkYXRhIGlz
IGluIDEgdGFibGU7IGF1dGhvcnMsIGNhdGVnb3JpZXMgJg0KcHVibGlzaGVy cyBhcmUgaW4gc2Vw
YXJhdGUgdGFibGVzIGJlY2F1c2Ugb2YgMSB0byBtYW55ICYgbWFueSB0byAx DQpyZWxhdGlvbnNo
aXBzLg0KU3RpbGwgYW5vdGhlciBwcm9ibGVtIGlzIHRoZSB1c2Ugb2YgYSBu dW1iZXIgb2YgZm9y
ZWlnbiBsYW5ndWFnZXMgd2hpY2gNCmhhdmUgdGhvc2Ugc3RyYW5nZSBhY2Nl bnQgb24gbWFueSBs
ZXR0ZXJzIHRoYXQgZG8gbm90IG9yZGVyIHZlcnkgd2VsbC4NCk5vdywgdGhh dCBJIGhhdmUgc3Bl
d2VkIG91dCBteSBwcm9ibGVtcywgd291bGQgaXQgYmUgcG9zc2libGUgdGhh dCB0aGVyZQ0KaXMg
c29tZW9uZSBvdXQgdGhlcmUgd2hvIGNvdWxkIHN1Z2dlc3QgaG93IHRvIGdv IGFib3V0IGZpZ3Vy
aW5nIHRoaXMgb3V0Pw0KVGhhbmtzIGluIGFkdmFuY2UuDQoNCi0tDQpIZXJ2 w6kgS2VtcGY6ICJQ
b3VyIHNhdXZlciBsYSBwbGFuw6h0ZSwgc29ydGV6IGR1IGNhcGl0YWxpc21l LiINCi0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NClBo
aWwgSm91cmRhbiAtLS0gcGpAcHRhaGhvdGVwLmNvbQ0KICAgaHR0cDovL3d3 dy5wdGFoaG90ZXAu
Y29tDQogICBodHRwOi8vd3d3LmNoaWNjYW50aW5lLmNvbS9hbmR5cGFudHJ5 LnBocA0KDQoNCi0t
DQpNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KRm9yIGxpc3QgYXJjaGl2 ZXM6IGh0dHA6Ly9s
aXN0cy5teXNxbC5jb20vbXlzcWwNClRvIHVuc3Vic2NyaWJlOiAgICBodHRw Oi8vbGlzdHMubXlz
cWwuY29tL215c3FsP3Vuc3ViPWd0b3dleUBmZm4uY29tDQoNCg0KVGhlIGlu Zm9ybWF0aW9uIGNv
bnRhaW5lZCBpbiB0aGlzIHRyYW5zbWlzc2lvbiBtYXkgY29udGFpbiBwcml2 aWxlZ2VkIGFuZCBj
b25maWRlbnRpYWwgaW5mb3JtYXRpb24uIEl0IGlzIGludGVuZGVkIG9ubHkg Zm9yIHRoZSB1c2Ug
b2YgdGhlIHBlcnNvbihzKSBuYW1lZCBhYm92ZS4gSWYgeW91IGFyZSBub3Qg dGhlIGludGVuZGVk
IHJlY2lwaWVudCwgeW91IGFyZSBoZXJlYnkgbm90aWZpZWQgdGhhdCBhbnkg cmV2aWV3LCBkaXNz
ZW1pbmF0aW9uLCBkaXN0cmlidXRpb24gb3IgZHVwbGljYXRpb24gb2YgdGhp cyBjb21tdW5pY2F0
aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBhcmUgbm90IHRo ZSBpbnRlbmRlZCBy
ZWNpcGllbnQsIHBsZWFzZSBjb250YWN0IHRoZSBzZW5kZXIgYnkgcmVwbHkg ZW1haWwgYW5kIGRl
c3Ryb3kgYWxsIGNvcGllcyBvZiB0aGUgb3JpZ2luYWwgbWVzc2FnZS4NCg==

RE: ordering search results

am 18.07.2009 00:45:13 von Gavin Towey

UGxlYXNlIGVjaG8gdGhlIHF1ZXJ5IGFuZCBzaG93IHRoZSBhY3R1YWwgcmVz dWx0LiAgV2UgaGF2
ZSBubyB3YXkgdG8ga25vdyB3aGF0IHlvdXIgcHJvZ3JhbSBwdXRzIGluIHlv dXIgdmFyaWFibGVz
LiAgVGhlIHByb2JsZW0gaXMgb2Z0ZW4gYSB0aGF0IGEgcHJvZ3JhbW1pbmcg ZXJyb3IgY2F1c2Vz
IHRoZSBjb2RlIHRvIGNvbnN0cnVjdCBhIHF1ZXJ5IHRoYXQncyBkaWZmZXJl bnQgZnJvbSB3aGF0
IHlvdSBhc3N1bWUuDQoNClJlZ2FyZHMsDQpHYXZpbiBUb3dleQ0KDQotLS0t LU9yaWdpbmFsIE1l
c3NhZ2UtLS0tLQ0KRnJvbTogUEogW21haWx0bzphZi5nb3VybWV0QHZpZGVv dHJvbi5jYV0NClNl
bnQ6IEZyaWRheSwgSnVseSAxNywgMjAwOSAxOjI1IFBNDQpUbzogRGFycnls ZSBTdGVwbGlnaHQN
CkNjOiBNeVNxbA0KU3ViamVjdDogUmU6IG9yZGVyaW5nIHNlYXJjaCByZXN1 bHRzDQoNCkhlcmUn
cyB0aGUgcXVlcnk6DQoiU0VMRUNUICogRlJPTSBib29rIE9SREVSIEJZICRz b3J0ICRkaXIgTElN
SVQgJG9mZnNldCwgJHJlY29yZHNfcGVyX3BhZ2UiOw0KJHNvcnQgPT0gJ3Rp dGxlLCBzdWJfdGl0
bGUnOyAkZGlyPT1BU0MgKG9yIERFU0MpOyAkb2Zmc2V0PT0gKGFueQ0KbXVs dGlwbGUgb2YgMTAp
OyAkcmVjb3Jkc19wZXJfcGFnZT09IDEwOw0KSSBjb3VsZCBsZXQgdGhlIHVz ZXIgY2hhbmdlIHRo
ZXNlLCBidXQgSSBkZWNpZGVkIGl0IGlzIHNpbXBsZXIgdG8ga2VlcA0KaXQg YXQgMTAgYm9va3Mv
cGFnZS4gT25seSB0aGUgJGRpciBpcyB1c2VyIHNldHRhYmxlLg0KVGhlIGNo YXJhY3RlciBzZXQg
aXMgdXRmOC1nZW5lcmFsOyAoSSBqdXN0IHdlbnQgdGhyb3VnaCBzb21lDQpz ZWxmLXRvcnR1cmUg
Y2hhbmdpbmcgYWxsIHRob3NlIGZvcmVpZ24gY3VybGljdWVzIHRvIDomY3V0 ZXN5X3N0dWZmOw0K
Zm9ydHVuYXRlbHksIHRoZSBteXNxbCByZXBsYWNlKCkgZnVuY3Rpb24gaGVs cGVkIC0gYnV0IHNp
eCBsYW5ndWFnZXMNCmhhdmUgcXVpdGUgYSBmZXcgd2VpcmQgYWNjZW50cy4N ClRoZSB0aXRsZSBm
aWVsZCBjYW4gYmUgZmFpcmx5IGxvbmcgLSAxODIgY2hhcnM7IHN1Yl90aXRs ZSBpcyAxMjgsIGJ1
dCBpdA0KbG9va3MgbGlrZSBJIGhhdmUgdG8gbGVuZ3RoZW4gdGhhdCB0b287 IGZvdW5kIHNvbWUg
dHJ1bmNhdGVkIGlucHV0cy4NCg0KQW5vdGhlciBwcm9ibGVtIGlzIHRoZSBU aGVzIC0gaG93IGRv
IHlvdSBleGNsdWRlIHRoZW0NCmZyb20gdGhlIG9yZGVyaW5nLg0KDQpBbHNv OiBvbmUgb3V0cHV0
IHdpdGgganVzdCB0aXRsZSBmb3IgZmllbGQgcmV0dXJuZWQgYSBzZXJpZXMg b2YgVGhlDQpBcnQu
LiwgVGhlIEJpcmRzLi4uLCBUaGUgQmlydGguLi5ldGMuIGluIEFTQzsgd2hl cmVhcyBERVNDIHJl
dHVybmVkOg0KQm9hdHMsIEJsYWNrIEN1bWluLCBCaXJkcyBvZi4uLiwgQmlv bG9naWNhbC4uLiwg
QmlvYXJjaGFlb2xvZ3kuLiwNCkF2YXJpcy4uLiBldGMuDQoNCg0KDQpEYXJy eWxlIFN0ZXBsaWdo
dCB3cm90ZToNCj4gWW91IG1pZ2h0IGhhdmUgdG8gY2hhbmdlIHRoZSBjb2xs YXRpb24geW91IGFy
ZSBjdXJyZW50bHkgdXNpbmcgdG8gb25lDQo+IHRoYXQgYmVzdCBtYXRjaCB0 aGUgbGFuZ3VhZ2Ug
b2YgdGhvc2Ugd2VpcmQgYWNjZW50cyB5b3UgYXJlIHJlZmVycmluZw0KPiB0 b28uIFRoYXQncyBw
YXJ0IG9mIHRoZSByZWFzb24geW91IG1heSBiZSBnZXR0aW5nIHVuZXhwZWN0 ZWQgcmVzdWx0cw0K
PiB3aXRoIHlvdXIgT1JERVIgQlkgc3RhdGVtZW50LiBBbHNvLCBjYW4geW91 IHNob3cgdXMgeW91
ciBzZWxlY3QNCj4gc3RhdGVtZW50cz8NCj4NCj4gT24gRnJpLCBKdWwgMTcs IDIwMDkgYXQgMTE6
MDYgQU0sIFBKPGFmLmdvdXJtZXRAdmlkZW90cm9uLmNhPiB3cm90ZToNCj4N Cj4+IENhbid0IGZp
bmQgYW55dGhpbmcgb24gdGhlIHdlYiB0aGF0IGRlYWxzIHdpdGggbXkgcHJv YmxlbShzKS4NCj4+
IEkgaGF2ZSB0byBkaXNwbGF5IHRob3VzYW5kcyBvZiBib29rIGxpc3Rpbmdz IGJ5IHRpdGxlLCBz
dWJfdGl0bGUgd2l0aCAxMA0KPj4gYm9va3MgcGVyIHBhZ2UuIFRoZSBwaHAv bXlzcWwgY29kZSB3
b3JrcyBmaW5lIC0gZXhjZXB0Og0KPj4gQVNDIG9yIERFU0MgZG9lcyBub3Qg Y2hhbmdlIG9uZSBp
b3RhLg0KPj4gSSBoYXZlIGNoZWNrZWQgYnkgY29tbWFuZGxpbmUgYW5kIGZp bmQgdGhhdCBpdCBp
cyBub3Qgd29ya2luZyBhdCBhbGwgaG93DQo+PiBJIHdvdWxkIGV4cGVjdC4N Cj4+IEZyb20gY29t
bWFuZGxpbmUsIHVzaW5nIGp1c3QgdGl0bGUgYW5kIHN3aXRjaGluZyBiZXR3 ZWVuIEFTQyAmIERF
U0MgZ2l2ZQ0KPj4gdG90YWxseSBkaWZmZXJlbnQgcmVzdWx0cyByYXRoZXIg dGhhbiBkaXNwbGF5
aW5nIHRoZSBzYW1lIGRhdGEgaW4NCj4+IHJldmVyc2Ugb3JkZXIuDQo+PiBU aGUgZGlzcGxheSBp
cywgYXMgbWVudGlvbmVkIGFib3ZlLCAxMCBib29rcyBwZXIgb3V0cHV0IHBh Z2U6IHNvLCBmcm9t
DQo+PiB3aGF0IGFwcGVhcnMgdG8gbWUsIHRoZSBvcmRlcmluZyBzZWVtcyB0 byBiZSBkb25lIG9u
IHRoZSBlbnRpcmUgZGIgJiBub3QNCj4+IGp1c3Qgb24gdGhlIHNlYXJjaCBy ZXN1bHRzICh0aGlz
IGlzIGJhc2ljYWxseSBmcm9tIGEgU0VMRUNUIHN0YXRlbWVudCkuDQo+PiBG dXJ0aGVybW9yZSwg
bm90IGFsbCB0aGUgZGF0YSBpcyBpbiAxIHRhYmxlOyBhdXRob3JzLCBjYXRl Z29yaWVzICYNCj4+
IHB1Ymxpc2hlcnMgYXJlIGluIHNlcGFyYXRlIHRhYmxlcyBiZWNhdXNlIG9m IDEgdG8gbWFueSAm
IG1hbnkgdG8gMQ0KPj4gcmVsYXRpb25zaGlwcy4NCj4+IFN0aWxsIGFub3Ro ZXIgcHJvYmxlbSBp
cyB0aGUgdXNlIG9mIGEgbnVtYmVyIG9mIGZvcmVpZ24gbGFuZ3VhZ2VzIHdo aWNoDQo+PiBoYXZl
IHRob3NlIHN0cmFuZ2UgYWNjZW50IG9uIG1hbnkgbGV0dGVycyB0aGF0IGRv IG5vdCBvcmRlciB2
ZXJ5IHdlbGwuDQo+PiBOb3csIHRoYXQgSSBoYXZlIHNwZXdlZCBvdXQgbXkg cHJvYmxlbXMsIHdv
dWxkIGl0IGJlIHBvc3NpYmxlIHRoYXQgdGhlcmUNCj4+IGlzIHNvbWVvbmUg b3V0IHRoZXJlIHdo
byBjb3VsZCBzdWdnZXN0IGhvdyB0byBnbyBhYm91dCBmaWd1cmluZyB0aGlz IG91dD8NCj4+IFRo
YW5rcyBpbiBhZHZhbmNlLg0KPj4NCj4+IC0tDQo+PiBIZXJ277+9IEtlbXBm OiAiUG91ciBzYXV2
ZXIgbGEgcGxhbu+/vXRlLCBzb3J0ZXogZHUgY2FwaXRhbGlzbWUuIg0KPj4g LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KPj4gUGhp
bCBKb3VyZGFuIC0tLSBwakBwdGFoaG90ZXAuY29tDQo+PiDvv70gaHR0cDov L3d3dy5wdGFoaG90
ZXAuY29tDQo+PiDvv70gaHR0cDovL3d3dy5jaGljY2FudGluZS5jb20vYW5k eXBhbnRyeS5waHAN
Cj4+DQo+Pg0KPj4gLS0NCj4+IE15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0 DQo+PiBGb3IgbGlz
dCBhcmNoaXZlczogaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbA0KPj4g VG8gdW5zdWJzY3Jp
YmU6IO+/vSDvv71odHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsP3Vuc3Vi PWRzdGVwbGlnaHRA
Z21haWwuY29tDQo+Pg0KDQotLQ0KSGVydsOpIEtlbXBmOiAiUG91ciBzYXV2 ZXIgbGEgcGxhbsOo
dGUsIHNvcnRleiBkdSBjYXBpdGFsaXNtZS4iDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpQaGlsIEpvdXJk YW4gLS0tIHBqQHB0
YWhob3RlcC5jb20NCiAgIGh0dHA6Ly93d3cucHRhaGhvdGVwLmNvbQ0KICAg aHR0cDovL3d3dy5j
aGljY2FudGluZS5jb20vYW5keXBhbnRyeS5waHANCg0KDQotLQ0KTXlTUUwg R2VuZXJhbCBNYWls
aW5nIExpc3QNCkZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlz cWwuY29tL215c3Fs
DQpUbyB1bnN1YnNjcmliZTogICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9t eXNxbD91bnN1Yj1n
dG93ZXlAZmZuLmNvbQ0KDQoNClRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQg aW4gdGhpcyB0cmFu
c21pc3Npb24gbWF5IGNvbnRhaW4gcHJpdmlsZWdlZCBhbmQgY29uZmlkZW50 aWFsIGluZm9ybWF0
aW9uLiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgdXNlIG9mIHRoZSBw ZXJzb24ocykgbmFt
ZWQgYWJvdmUuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGll bnQsIHlvdSBhcmUg
aGVyZWJ5IG5vdGlmaWVkIHRoYXQgYW55IHJldmlldywgZGlzc2VtaW5hdGlv biwgZGlzdHJpYnV0
aW9uIG9yIGR1cGxpY2F0aW9uIG9mIHRoaXMgY29tbXVuaWNhdGlvbiBpcyBz dHJpY3RseSBwcm9o
aWJpdGVkLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50 LCBwbGVhc2UgY29u
dGFjdCB0aGUgc2VuZGVyIGJ5IHJlcGx5IGVtYWlsIGFuZCBkZXN0cm95IGFs bCBjb3BpZXMgb2Yg
dGhlIG9yaWdpbmFsIG1lc3NhZ2UuDQo=

RE: ordering search results

am 18.07.2009 00:50:24 von Gavin Towey

SSB0aGluayBJIHNlZSBpdCBhbnl3YXk6DQoNCk9SREVSIEJZIHRpbGUgREVT Qywgc3ViX3RpdGxl
IEFTQw0KDQpFYWNoIGl0ZW0gaW4gdGhlIGxpc3QgZmllbGRzIHRha2VzIEFT Qy9ERVNDIGluZGl2
aWR1YWxseS4gIFlvdXIgc3RhdGVtZW50IHdvdWxkIG9ubHkgY2hhbmdlIHRo ZSBzb3J0IG9yZGVy
IG9uIHRoZSBzZWNvbmQgY29sdW1uLCBub3QgYm90aC4NCg0KDQoNCi0tLS0t T3JpZ2luYWwgTWVz
c2FnZS0tLS0tDQpGcm9tOiBQSiBbbWFpbHRvOmFmLmdvdXJtZXRAdmlkZW90 cm9uLmNhXQ0KU2Vu
dDogRnJpZGF5LCBKdWx5IDE3LCAyMDA5IDE6MjUgUE0NClRvOiBEYXJyeWxl IFN0ZXBsaWdodA0K
Q2M6IE15U3FsDQpTdWJqZWN0OiBSZTogb3JkZXJpbmcgc2VhcmNoIHJlc3Vs dHMNCg0KSGVyZSdz
IHRoZSBxdWVyeToNCiJTRUxFQ1QgKiBGUk9NIGJvb2sgT1JERVIgQlkgJHNv cnQgJGRpciBMSU1J
VCAkb2Zmc2V0LCAkcmVjb3Jkc19wZXJfcGFnZSI7DQokc29ydCA9PSAndGl0 bGUsIHN1Yl90aXRs
ZSc7ICRkaXI9PUFTQyAob3IgREVTQyk7ICRvZmZzZXQ9PSAoYW55DQptdWx0 aXBsZSBvZiAxMCk7
ICRyZWNvcmRzX3Blcl9wYWdlPT0gMTA7DQpJIGNvdWxkIGxldCB0aGUgdXNl ciBjaGFuZ2UgdGhl
c2UsIGJ1dCBJIGRlY2lkZWQgaXQgaXMgc2ltcGxlciB0byBrZWVwDQppdCBh dCAxMCBib29rcy9w
YWdlLiBPbmx5IHRoZSAkZGlyIGlzIHVzZXIgc2V0dGFibGUuDQpUaGUgY2hh cmFjdGVyIHNldCBp
cyB1dGY4LWdlbmVyYWw7IChJIGp1c3Qgd2VudCB0aHJvdWdoIHNvbWUNCnNl bGYtdG9ydHVyZSBj
aGFuZ2luZyBhbGwgdGhvc2UgZm9yZWlnbiBjdXJsaWN1ZXMgdG8gOiZjdXRl c3lfc3R1ZmY7DQpm
b3J0dW5hdGVseSwgdGhlIG15c3FsIHJlcGxhY2UoKSBmdW5jdGlvbiBoZWxw ZWQgLSBidXQgc2l4
IGxhbmd1YWdlcw0KaGF2ZSBxdWl0ZSBhIGZldyB3ZWlyZCBhY2NlbnRzLg0K VGhlIHRpdGxlIGZp
ZWxkIGNhbiBiZSBmYWlybHkgbG9uZyAtIDE4MiBjaGFyczsgc3ViX3RpdGxl IGlzIDEyOCwgYnV0
IGl0DQpsb29rcyBsaWtlIEkgaGF2ZSB0byBsZW5ndGhlbiB0aGF0IHRvbzsg Zm91bmQgc29tZSB0
cnVuY2F0ZWQgaW5wdXRzLg0KDQpBbm90aGVyIHByb2JsZW0gaXMgdGhlIFRo ZXMgLSBob3cgZG8g
eW91IGV4Y2x1ZGUgdGhlbQ0KZnJvbSB0aGUgb3JkZXJpbmcuDQoNCkFsc286 IG9uZSBvdXRwdXQg
d2l0aCBqdXN0IHRpdGxlIGZvciBmaWVsZCByZXR1cm5lZCBhIHNlcmllcyBv ZiBUaGUNCkFydC4u
LCBUaGUgQmlyZHMuLi4sIFRoZSBCaXJ0aC4uLmV0Yy4gaW4gQVNDOyB3aGVy ZWFzIERFU0MgcmV0
dXJuZWQ6DQpCb2F0cywgQmxhY2sgQ3VtaW4sIEJpcmRzIG9mLi4uLCBCaW9s b2dpY2FsLi4uLCBC
aW9hcmNoYWVvbG9neS4uLA0KQXZhcmlzLi4uIGV0Yy4NCg0KDQoNCkRhcnJ5 bGUgU3RlcGxpZ2h0
IHdyb3RlOg0KPiBZb3UgbWlnaHQgaGF2ZSB0byBjaGFuZ2UgdGhlIGNvbGxh dGlvbiB5b3UgYXJl
IGN1cnJlbnRseSB1c2luZyB0byBvbmUNCj4gdGhhdCBiZXN0IG1hdGNoIHRo ZSBsYW5ndWFnZSBv
ZiB0aG9zZSB3ZWlyZCBhY2NlbnRzIHlvdSBhcmUgcmVmZXJyaW5nDQo+IHRv by4gVGhhdCdzIHBh
cnQgb2YgdGhlIHJlYXNvbiB5b3UgbWF5IGJlIGdldHRpbmcgdW5leHBlY3Rl ZCByZXN1bHRzDQo+
IHdpdGggeW91ciBPUkRFUiBCWSBzdGF0ZW1lbnQuIEFsc28sIGNhbiB5b3Ug c2hvdyB1cyB5b3Vy
IHNlbGVjdA0KPiBzdGF0ZW1lbnRzPw0KPg0KPiBPbiBGcmksIEp1bCAxNywg MjAwOSBhdCAxMTow
NiBBTSwgUEo8YWYuZ291cm1ldEB2aWRlb3Ryb24uY2E+IHdyb3RlOg0KPg0K Pj4gQ2FuJ3QgZmlu
ZCBhbnl0aGluZyBvbiB0aGUgd2ViIHRoYXQgZGVhbHMgd2l0aCBteSBwcm9i bGVtKHMpLg0KPj4g
SSBoYXZlIHRvIGRpc3BsYXkgdGhvdXNhbmRzIG9mIGJvb2sgbGlzdGluZ3Mg YnkgdGl0bGUsIHN1
Yl90aXRsZSB3aXRoIDEwDQo+PiBib29rcyBwZXIgcGFnZS4gVGhlIHBocC9t eXNxbCBjb2RlIHdv
cmtzIGZpbmUgLSBleGNlcHQ6DQo+PiBBU0Mgb3IgREVTQyBkb2VzIG5vdCBj aGFuZ2Ugb25lIGlv
dGEuDQo+PiBJIGhhdmUgY2hlY2tlZCBieSBjb21tYW5kbGluZSBhbmQgZmlu ZCB0aGF0IGl0IGlz
IG5vdCB3b3JraW5nIGF0IGFsbCBob3cNCj4+IEkgd291bGQgZXhwZWN0Lg0K Pj4gRnJvbSBjb21t
YW5kbGluZSwgdXNpbmcganVzdCB0aXRsZSBhbmQgc3dpdGNoaW5nIGJldHdl ZW4gQVNDICYgREVT
QyBnaXZlDQo+PiB0b3RhbGx5IGRpZmZlcmVudCByZXN1bHRzIHJhdGhlciB0 aGFuIGRpc3BsYXlp
bmcgdGhlIHNhbWUgZGF0YSBpbg0KPj4gcmV2ZXJzZSBvcmRlci4NCj4+IFRo ZSBkaXNwbGF5IGlz
LCBhcyBtZW50aW9uZWQgYWJvdmUsIDEwIGJvb2tzIHBlciBvdXRwdXQgcGFn ZTogc28sIGZyb20N
Cj4+IHdoYXQgYXBwZWFycyB0byBtZSwgdGhlIG9yZGVyaW5nIHNlZW1zIHRv IGJlIGRvbmUgb24g
dGhlIGVudGlyZSBkYiAmIG5vdA0KPj4ganVzdCBvbiB0aGUgc2VhcmNoIHJl c3VsdHMgKHRoaXMg
aXMgYmFzaWNhbGx5IGZyb20gYSBTRUxFQ1Qgc3RhdGVtZW50KS4NCj4+IEZ1 cnRoZXJtb3JlLCBu
b3QgYWxsIHRoZSBkYXRhIGlzIGluIDEgdGFibGU7IGF1dGhvcnMsIGNhdGVn b3JpZXMgJg0KPj4g
cHVibGlzaGVycyBhcmUgaW4gc2VwYXJhdGUgdGFibGVzIGJlY2F1c2Ugb2Yg MSB0byBtYW55ICYg
bWFueSB0byAxDQo+PiByZWxhdGlvbnNoaXBzLg0KPj4gU3RpbGwgYW5vdGhl ciBwcm9ibGVtIGlz
IHRoZSB1c2Ugb2YgYSBudW1iZXIgb2YgZm9yZWlnbiBsYW5ndWFnZXMgd2hp Y2gNCj4+IGhhdmUg
dGhvc2Ugc3RyYW5nZSBhY2NlbnQgb24gbWFueSBsZXR0ZXJzIHRoYXQgZG8g bm90IG9yZGVyIHZl
cnkgd2VsbC4NCj4+IE5vdywgdGhhdCBJIGhhdmUgc3Bld2VkIG91dCBteSBw cm9ibGVtcywgd291
bGQgaXQgYmUgcG9zc2libGUgdGhhdCB0aGVyZQ0KPj4gaXMgc29tZW9uZSBv dXQgdGhlcmUgd2hv
IGNvdWxkIHN1Z2dlc3QgaG93IHRvIGdvIGFib3V0IGZpZ3VyaW5nIHRoaXMg b3V0Pw0KPj4gVGhh
bmtzIGluIGFkdmFuY2UuDQo+Pg0KPj4gLS0NCj4+IEhlcnbvv70gS2VtcGY6 ICJQb3VyIHNhdXZl
ciBsYSBwbGFu77+9dGUsIHNvcnRleiBkdSBjYXBpdGFsaXNtZS4iDQo+PiAt LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQo+PiBQaGls
IEpvdXJkYW4gLS0tIHBqQHB0YWhob3RlcC5jb20NCj4+IO+/vSBodHRwOi8v d3d3LnB0YWhob3Rl
cC5jb20NCj4+IO+/vSBodHRwOi8vd3d3LmNoaWNjYW50aW5lLmNvbS9hbmR5 cGFudHJ5LnBocA0K
Pj4NCj4+DQo+PiAtLQ0KPj4gTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExpc3QN Cj4+IEZvciBsaXN0
IGFyY2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQo+PiBU byB1bnN1YnNjcmli
ZTog77+9IO+/vWh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWw/dW5zdWI9 ZHN0ZXBsaWdodEBn
bWFpbC5jb20NCj4+DQoNCi0tDQpIZXJ2w6kgS2VtcGY6ICJQb3VyIHNhdXZl ciBsYSBwbGFuw6h0
ZSwgc29ydGV6IGR1IGNhcGl0YWxpc21lLiINCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NClBoaWwgSm91cmRh biAtLS0gcGpAcHRh
aGhvdGVwLmNvbQ0KICAgaHR0cDovL3d3dy5wdGFoaG90ZXAuY29tDQogICBo dHRwOi8vd3d3LmNo
aWNjYW50aW5lLmNvbS9hbmR5cGFudHJ5LnBocA0KDQoNCi0tDQpNeVNRTCBH ZW5lcmFsIE1haWxp
bmcgTGlzdA0KRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNx bC5jb20vbXlzcWwN
ClRvIHVuc3Vic2NyaWJlOiAgICBodHRwOi8vbGlzdHMubXlzcWwuY29tL215 c3FsP3Vuc3ViPWd0
b3dleUBmZm4uY29tDQoNCg0KVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBp biB0aGlzIHRyYW5z
bWlzc2lvbiBtYXkgY29udGFpbiBwcml2aWxlZ2VkIGFuZCBjb25maWRlbnRp YWwgaW5mb3JtYXRp
b24uIEl0IGlzIGludGVuZGVkIG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIHBl cnNvbihzKSBuYW1l
ZCBhYm92ZS4gSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVu dCwgeW91IGFyZSBo
ZXJlYnkgbm90aWZpZWQgdGhhdCBhbnkgcmV2aWV3LCBkaXNzZW1pbmF0aW9u LCBkaXN0cmlidXRp
b24gb3IgZHVwbGljYXRpb24gb2YgdGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0 cmljdGx5IHByb2hp
Yml0ZWQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQs IHBsZWFzZSBjb250
YWN0IHRoZSBzZW5kZXIgYnkgcmVwbHkgZW1haWwgYW5kIGRlc3Ryb3kgYWxs IGNvcGllcyBvZiB0
aGUgb3JpZ2luYWwgbWVzc2FnZS4NCg==