08 April 2004

PHP/MySQL hell...

I mangled up a lil script to fix some problems with the database that I use on Stocky Jock but now I can’t for the life of me figure out how the %@#& to do a reverse sort on a key.

I want to show the “all profiles” in reverse order, that is newest to oldest (higher # to lower #). I know it’s possible, I’ve seen code snippets...but for some reason, it’s just not wedging into my head as to how or why it works.

It’s not a major pain in the @$$ but added to the three hours wasted on figuring out (read that as: remember enough php) to repopulate a database field...I’m *really* cranky.

It has to be easy...it just has to be...I mean it’s a simple reverse search through a paginator....

I’m letting the code sit for a while...and I’m going to work on my novel for a while...I need to work off a lot of excess energy.

2 comments:

cpj said...

If it was perl, I could help you. (it's rev() ).

bigbearjt said...

the problem is feeding the array in 10 unit chunks into the paginator and keeping it reversed. I'm thinking I'm going to have to completely rewrite the code for the "View All Profiles" section to do this.