FAQ insists on putting questions in alaphabetical order :: Archived

SangFori · Newbie Offline Joined: Nov 23, 2004 Posts: 27

How do I stop it, and keep them in the order I put the questions in? I searched the forums to no avail.

Trevor

Open modules/FAQ/index.php, find on line 29:

PHP:

$sql = "SELECT id, question, answer FROM ".$prefix."_faqanswer WHERE id_cat='$id_cat' ORDER BY question $order";

Replace with:

PHP:

$sql = "SELECT id, question, answer FROM ".$prefix."_faqanswer WHERE id_cat='$id_cat' ORDER BY id $order";

SangFori · Newbie Offline Joined: Nov 23, 2004 Posts: 27

thank you Trevor