Fiction
Archives
Sort by: Title | Date
switch($sort)
{
case a: $sort = 'doc_creator1';
break;
case d: $sort = 'date';
break;
default: $sort = 'sortName';
}
$rowquery = "SELECT date_format(date, '%M %d, %Y') as realdate, doc_creator1, date, doc_number, title, tagline, CASE WHEN title LIKE 'The %' THEN replace(title, 'The ', '') WHEN title LIKE 'A %' THEN replace(title, 'A ', '') WHEN title LIKE 'An %' THEN replace(title, 'An ', '') WHEN title LIKE '\"%' THEN replace(title, '\"', '') WHEN title LIKE '\'%' THEN replace(title, '\'', '') WHEN title LIKE '\". . . %' THEN replace(title, '\". . . ', '') WHEN title LIKE '\" . . . %' THEN replace(title, '\" . . . ', '') WHEN title LIKE '. . . %' THEN replace(title, '. . . ', '') WHEN title LIKE '...%' THEN replace(title, '...', '') ELSE title END AS sortName FROM content WHERE doc_type='Fiction' and access != 'Restricted' GROUP BY $sort ASC";
$new_result = mysql_db_query("revolutionsf_com", $rowquery, $mysql_link);
while($row = mysql_fetch_array($new_result))
{
print("$row[title] $row[realdate]: $row[tagline] ");
print(" ");
}
?>
|
|
include("/home/revsf/revolutionsf-www/php/rightnavfront.php");
?>
|