Sorting Problem (PHP+SQL)

[MesCasinos]

HI,

 

- First I've attached the original PHP file, which you will need. This file is included in a page.

- Second, sorry for my english, this is not my primary language 

 

Ok, the page I've attached currently dont sort the casinos: http://www.mescasinos.net/meilleurs-casinos.php

 

In my webpage, you can see the overal rating with the stars which is the average of fields ['note_'] for each casinos, this rating is made by mathematic (line 45):

 

$number = ($row['note_rep'] + $row['note_graph'] + $row['note_bmatch'] + $row['note_bmax'] + $row['note_bgratuit'] + $row['note_jackpot'] + $row['note_varjeux'] + $row['note_languages'] + $row['note_bloyauter'] + $row['note_jeuxmulti'] + $row['note_metpaiement'] + $row['note_metretrait'] + $row['note_support'])/13;

 

 

I want to get my casinos sorted DESC by this overal rating

 

Normaly, to get something sorted i use:

$result = mysql_query("SELECT * FROM casinos ORDER BY something DESC");

 

But here the average is $number and i can't use it in the "mysql_query" and in the "while"

 

This is how i think the things must be but im not sure if thats the good way to make it:

 

should make the average of all the fields ['note_'] for each casinos in my table and sort them after

 

Example:

 

Table "casinos"

 

 

   

nom

   

note_rep

   

note_graph

   

note_support

   

bonus

 

 

   

tropez

   

9

   

6

   

6

   

100%

 

 

   

rushmore

   

8

   

7

   

9

   

150%

 

 

   

bellini

   

9

   

9

   

9

   

100%

 

 

The average of tropez is 7.6

The average of rushmore is 8

The average of bellini is 9

 

so in my webpage the casinos will be sorted:

 

bellini

rushmore

tropez

 

I hope you guys understand what i want say 

 

[attachment deleted by admin]