FAQ Manager

[tcjay]

OK... had a bit to look over what I did and the old code. The FAQ uses a file to change 'order by' in the sql statement depending on selections in your configuration.

includes\templates\YOUR_TEMPLATE\templates\tpl_faq_default.php

needs a 'order by fc.sort_order, fcd.faq_categories_name' to get the categories names and such, but there is none matching this in

includes\modules\faq_listing_display_order.php

You can rewrite the sql statements so they work, or try to fix it in faq_listing_display_order.php, I was rewriting much of the code so changing the sql statements worked for me.

Try changing this line in includes\modules\faq_listing_display_order.php

$order_by = " order by fc.sort_order, f.faqs_sort_order";

to this and see if it works..

$order_by = " order by fc.sort_order, fcd.faq_categories_name";

Doing sorts on two tables in one sql statement is strange.... more then likely where the error was.

Not sure if this will work for you.... couldn't get a good test going.. I don't use faq_listing_display_order.php even through I left it in place, just hard coded the 'order by' .

I would like to sort display all of the faq's with a primary sort by category. I think that is what is discussed above. I am just not sure where to the the change $order_by = " order by fc.sort_order, f.faqs_sort_order

I would like to hard code it and then take away the drop down box giving the different sort options. Can you clarify where I need to make the change to the code. TIA Tom