PHP help - Need help with putting a list into order

[Ashleyuk1984]

I have been coding up a little something, but I'm stuck at literally the last hurdle.

This is part of the code that I have:

query_posts($query_string . '&cat=203&posts_per_page=20');

That lists the latest 20 posts from category 203 (which is movies for me).



But now the part that I'm stuck with.
I want THAT list above (latest posts), to be in alphabetical order.

I have tried 'orderby=title', but that lists from the very beginning (posts that I made back in 2010) I don't want that.

So can anyone tell me the final piece of code that I have to add above in order to do that.
Thanks

Ashleyuk1984 Reviewed by Ashleyuk1984 on 9th Feb 2012. PHP help - Need help with putting a list into order I have been coding up a little something, but I'm stuck at literally the last hurdle. This is part of the code that I have: query_posts($query_string . '&cat=203&posts_per_page=20'); That lists the latest 20 posts from category 203 (which is movies for me). http://releasethread.com/uploadedimages/r98voe.png But now the part that I'm stuck with. I want THAT list above (latest posts), to be in alphabetical order. Rating: 5

[Gavo]

This site is using a hacked database of W junction

[Ashleyuk1984]

Thanks for the reply Gavo.
I presume that you are reffering to this:

'&orderby=title&order=ASC' 

However it's not exactly that I want.
This is the result:


As you can see, although this is in alphabetical order, this is not the same same list that I have above (in my first post).
This is listing EVERYTHING... however, I just want it to list the latest 20 posts - in alphabetical order.

Please see the list of posts in my very first picture in my original post.
I want THAT list of the latest 20 posts in alphabetical order.

[Loonycgb2]

&orderby=rowname (this would be where your getting the title names from)

Dont know much about this but reading off the page he linked to thats what has to be used

edit: i see you got it but your going to need to use desc also to get latest posts

[t3od0r]

you tried this?

&cat=203&posts_per_page=20&orderby=title&order=ASC'

[Ashleyuk1984]

Yeah I have, that's what gives me the 2nd image above, which isn't what I want.

[Robin H]

I'll think you'll need to edit the query for that.

SELECT * FROM tblLulz WHERE fldPrimaryKey > ((SELECT MAX(fldPrimaryKey) FROM tblLulz) - 10) ORDER BY DESC

I'm not sure you can use custom queries in wordpress.

edit:

Or do what gavo said..

He suggests to put your result in an array, and then sort the array.
Which works too.

[Ashleyuk1984]

Unfortunately I don't know anything about arrays, or how to code them.
I'm already out of my depth with the current progress that I have made lol

[Halcyon]

Can you post a snippet of the code that displays the above list?

It would be a lot easier to provide you with a solution then