Frequently Asked Questions

Sort sites by subject or date opened?

Sort sites by subject or date opened?
Posted on May 21, 2004
Written by Sasha (view more by Sasha)
Filed under FAQ, Flinx: Customize, Scripts

How can I change Flinx Collective so that it will sort my sites by Subject or Date Opened instead of Title?

Open category.php, and find this line:

$result = mysql_query("SELECT * FROM $table_link WHERE relCatID=$id ORDER BY title ASC");

Change it to this for sort by subject:

$result = mysql_query("SELECT * FROM $table_link WHERE relCatID=$id ORDER BY subject ASC");

Or this for sort by date:

$result = mysql_query("SELECT * FROM $table_link WHERE relCatID=$id ORDER BY date ASC");