Assistance needed with sorting Categories by name

favtm · Post by **favtm** » 31 Jan 2009, 14:02

I am too new to PHP to know what I am doing. I coded all my sites with HTML the past 10 years. I'm converting my site to a PHP layout and am learning as I go. I have one final itty bitty thing to fix before I can launch the site. I have searched google and 5 other forums regarding this with no working solution. But it's possible I'm not asking the right Q--here goes...

http://www.trojanlibrary.com/3.0/module ... me=Content

The link above is a visualization of my dilema. My Library--or Content page--is simply out of order. It does not appear to be in CID or PID so I'm flustered as to what order it's listed in, and how to change it to alphabetical.

My gosh I'm too embaressed to launch the site with this out of whack. It looks ridiculous doesn't it?

My Q is, what page must I edit, and what must I edit? Thank you so much for any advice in advance.

Still_Learning · Post by **Still_Learning** » 31 Jan 2009, 14:16

Props on the site.. good job, Ive needed a resource like this. As for the code I can not help I am still learning all of this stuff at school

Post by **bad_brain** » 31 Jan 2009, 14:33

a phpnuke module/block that is, right? you will have to post the source code, else it's kinda impossible to help...you can do it at http://code.suck-o.com , simply post the link(s) here then....

favtm · Post by **favtm** » 01 Feb 2009, 00:10

Alrigthty, grazi for the help. But I'm not sure which php page to post. Would it be mainfile.php or module.php, and which one? There's more than one depending on which folder I open.

Sigh, I'm back to basics.

Post by **DNR** » 01 Feb 2009, 00:16

hey Fav,
BB means to post YOUR PHP code at this link - the forum will not accept PHP code in this thread.

So post your PHP code here

http://code.suck-o.com

and then link to it here in the forum.

The guys that deal in PHP will review and resubmit your code!

Good to see ya, I am off to bed!

DNR

Post by **bad_brain** » 01 Feb 2009, 05:24

it should be the file(s) in /modules/Content/, most likely the index.php one...

favtm · Post by **favtm** » 01 Feb 2009, 12:17

Thanks Bad Brain for the clarification. Below you will find the link to the code of the index page found in the modules/Content folder.

http://code.suck-o.com/136

This was the page I actually edited a little. I changed all the 'ORDER BY date' to 'ORDER BY title' but still didn't work--but I left them as title anyway.

Post by **bad_brain** » 01 Feb 2009, 12:52

ok, I think the query that you will have to edit is in line 195:

Code: Select all

$result = $db->sql_query("SELECT * FROM ".$prefix."_pages_categories");

best open the database with phpmyadmin, and check the structure of the table named "page_categories", the cell that includes the A, B,C, etc. is the one that should be used for ORDER BY....let's say the cell is named "category_id" for example, it would be:

Code: Select all

$result = $db->sql_query("SELECT * FROM ".$prefix."_pages_categories ORDER BY category_id");

favtm · Post by **favtm** » 01 Feb 2009, 14:00

lol BB I can't tell you how relieved I am. I appreciate your assistance tremendously. I ended up sorting it by title and now it's sorted as it should be. TLN should be up again in no time.

Post by **bad_brain** » 01 Feb 2009, 14:24

you're welcome...