[Darnell 0216]

Originally Posted by CricketWeb

I'm trying to order my games in alphabetical order. I've added this:

	// Selects all games from the database
	$result_allgames = $DB_site->query("
		SELECT * FROM " . TABLE_PREFIX . "games $searchclause ORDER BY shortname asc
	");

but the "ORDER BY shortname asc" orders them in descending order and when I use desc it does the same thing.

Any ideas guys?

My arcade can be viewed here - http://forum.cricketweb.net/arcade.php?

Try capitalizing ASC. SQL commands are case sensitive in some usages.

ORDER BY title ASC