Who is here? 1 guest(s)
 Print Thread
MySql?
daimonbok
If a database has the following components:

faq_cat_id Faq_cat_came


1 Mary
2 Bill
3 Harry
4 Nancy
5 Andy

And I edit the db to alphabetize them like this:

1 Andy
2 Bill
3 Harry
4 Mary
5 Nancy

Would it any way damage the database to where Fusion wouldn't be able to read it?
 
NetriX
You only need to edit the sql query with php.

I suggest reading this: https://www.w3schools.com/sql/sql_ord...rderby.asp

$query = "SELECT Faq_cat_came, Faq_cat_id FROM ".DB_PREFIX." ORDER BY Faq_cat_came ASC";


That would sort the faq cat names alphabetically.

Been meaning to follow up with your faq question earlier this week, still very busy at work being at amazon.com during peak season. And to boot, I spilled a whole cup of tea on my keyboard so it's drying out.. AHH!!
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» My support days are usually Sun-Wed. Send me a PM if urgent.
 
daimonbok
Been there with the coffee on the keyboard myself, so I know the feeling....Thanks for the reply Netrix, I'll see which page I need to add that code to.

D'oH, I see one mistake I made.....faq_cat_came? Should have been faq_cat_name...

Again, thanks Netrix!
 
Advertisement
daimonbok
Can't figure out which page to place code on, my guess is faq.inc?
 
Advertisement
daimonbok
Edited the database by hand....changed the cat_id on the faq's first, then changed the numbering on the faq_cats by hand...took most of the afternoon, and I'll never do that again on line.....
 
Jump to Forum: