How to ad alphabetical sorting to indexer script

Original - php Code select * FROM dbname ORDER BY fieldname ASC LIMIT 50"

 
select * FROM dbname ORDER BY fieldname ASC LIMIT 50" 

function echo_links($filelisting, $number, $download_dir, $counter_dir, $phrase1, $phrase2, $PHP_SELF) // echos the links to each file
	{
	$number=$number-1;
	@sort($filelisting); // sorts the array $filelisting
	while($number>="0")
		{
		$file=$filelisting[$number];
		$linkfile=$file; // saves the correct path to the linkfile for future use.
		$file=ereg_replace( "$download_dir", '', $file ); // Strips the $download_dir from $file
		$counter_file = fopen("$counter_dir$file.txt","a+"); // open download counter
		rewind($counter_file);
		$count = fread($counter_file, 100);
		$number=$number-1; // decrements the variable $number to make the while function to end in a reasonable amount of time
		echo // echo link an additional infos
		"<li><font size="2" face="Arial, Helvetica, sans-serif"><b><a href="iup.php?file=$file">$file</a><i> ".date("d/m/Y G:i:s",filemtime($linkfile))."</b></font></i>";
		if($count>0)
			{