Alphabetizing Entries in Encyclopedia ORDER BY...

Nuke Soldier Joined: Feb 06, 2004 Posts: 16

I am using php 7.0....here is a sample out of encylcopedia module's index.php file:

Code:

function terms($eid, $ltr) {
global $module_name, $prefix, $sitename, $db, $admin;
$sql = "SELECT active FROM ".$prefix."_encyclopedia WHERE eid='$eid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$active = $row[active];
$sql = "SELECT title FROM ".$prefix."_encyclopedia WHERE eid='$eid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$title = $row[title];
include("header.php");
title("$title");
OpenTable();
if (($active == 1) OR (is_admin($admin))) {
if (($active != 1) AND (is_admin($admin))) {
echo "<center>"._YOURADMINENCY."</center><br><br>";
}
echo "<center>Please select one term from the following list:</center><br><br>"
."<table border=\"0\" align=\"center\">";
$sql = "SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'";
$result = $db->sql_query($sql);
$numrows = $db->sql_numrows($result);

Can I use an ORDER BY statement in this function to properly alphabetize my encyclopedia entries, and if so, where??? I have been dying to find a way to do this, please help....I think I have to do something like this:

Code:

sql_query("SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid' ORDER BY title ASC", $dbi);

but need further help....

Nuke Soldier Joined: Feb 06, 2004 Posts: 16

I need further help because I keep getting PARSE Error messages when I add that command (ORDERY BY ....)

Nuke Soldier Joined: Feb 06, 2004 Posts: 16

I've searched many similar topics here, and they all say the same thing... but how come when I do what everyone says, I get the parse error?

Captain Joined: Jan 05, 2004 Posts: 425

Encyclopedia enteries are already alphabatized. If you view the terms in each encyclopedia they are fine.

Are you asking how to put the list of encyclopedias into alphabetical order??

Putting the lists of encyclopedias into order would be a different spot in the code from what you posted.

To put the list of encyclopedia's in order find this:

Code:

$sql = "SELECT eid, title, description, elanguage FROM ".$prefix."_encyclopedia WHERE active='1'";

In /modules/Encyclopedia/index.php in the list_themes() function.

Change it to:

Code:

$sql = "SELECT eid, title, description, elanguage FROM ".$prefix."_encyclopedia WHERE active='1' ORDER BY title ASC";

That will put your list of Encyclopedia's into order for you.

Let me know if this is what you wanted.

Darrell

Nuke Soldier Joined: Dec 10, 2005 Posts: 21

I dont know if thats what he wanted, but it's sorted me. Thanks.

Nuke Soldier Joined: May 30, 2005 Posts: 23

/modules/Encyclopedia/index.php

Find:

Code:

$result3 = $db->sql_query("SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'");

Replace with:

Code:

$result3 = $db->sql_query("SELECT tid, title FROM ".$prefix."_encyclopedia_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'ORDER BY title ASC");

I did this and works for me.