General Community > Scripting Help

order by subject disordered

<< < (2/3) > >>

Anguz:
no, the weird sorting was just the same, only without the sticky thread at the top

 ???

I really can't understand...

is it possible to order the threads AFTER getting them from the db? probably PHP does a better job at it than MySQL... ::)

[Unknown]:
Not in YaBB SE 1.5.x...

Try sorting by posterName and seeing how badly that does...

Very, very odd.

-[Unknown]

Anguz:
I tried it too, when I first installed the A.M.A.'s mod in my test board, but it did the same

when I saw was that dates were sorted correctly, but text wasn't, like in poster name (started or replied) and subject

I also noticed that when changing the subject in the board I linked to above, many threads (maybe all, I didn't check that with particular attention) stayed in the same place, even though I'd just changed the begging of the thread from text to numbers

I was wondering if it's using something else to order the threads, instead of the actual subject string... but I have no idea what it could be... if you check the last page of that board, most of the threads are in proper order

in the test board where I tried the subject thing first, most of the threads were correctly ordered, even if it was text, but there was one completely out of place... lemme look for the url...

http://llama.lewismedia.com/~anguz/forums/index.php?board=19

it's sorted the same way as the one in the first message of this thread

... why isn't it possible to sort the threads with php? can't they be stored in an array and then sorted before displaying them?

Anguz:
the board I linked to in the first post is not ordered by subject anymore, at least while I find a solution for this

the board I linked to in the previous post is still the same, so you can see the problem there

A.M.A:
Your code is ok .. I guess
The problem will accrue when there is RE:xxx in the first thread! It will sort according to the subject (if there is more than one in the same thread it will sort the last one)!
You cannot determine the first subject of a thread by using (xxx_messages) table only! It must be linked to (xxx_topics) using the (ID_FIRST_MSG) field!

Navigation

[0] Message Index

[#] Next page

[*] Previous page