[SOLVED] Sort based on the value of a variable

[webweever]

I'm trying to sort my results based on the value of $average_vote, is this possible? I haven’t been able to find any type of example in the forum or via Professor Google.

 

<?php
include("includes/db.php");
   $sql = "SELECT * 
		FROM ratings 
		JOIN
		markers
		ON markers.marker_id = ratings.id
		LIMIT 5
		"; 
   
$result = mysql_query($sql) or trigger_error('Select SQL failed.', E_USER_ERROR);
$num_rows = mysql_num_rows($result);
	if ($num_rows < 1) {
		echo '<span class="text">Error</span>'; 
	}else {
		while ($row = mysql_fetch_assoc($result)) {
			$total_votes = $row['total_votes'];
			$total_value = $row['total_value'];
			$average_vote = $total_value / $total_votes;
			echo '<span class="text"><b>'.$row['name'].'</b><br/>Fan Rating: '.$average_vote.'</span><br/><br/>';
			} 
		}
?>

 

[.josh]

remove average_note stuff from your php and put it in your query and then sort by it

 

... ( total_value / total_votes ) as average_note ... order by average_note

[webweever]

I see, got it thanks.