Forgot password? | Forgot username? | Register

SQL 1st team

SQL 1st team

Hello,
I need select 1st team from season, by points, can you help me with this query? I dont know how to do it?

Thanks

Administrator has disabled public posting. Please login or register in order to proceed.

Re: SQL 1st team

Hello MATUTOicek ,

As I know you cant' do it in a single SQL query because the calculation of total point number is dynamically done for each season. This total points number is not saved in a SQL table.

If you want to do it, I think that you'll have to create PHP code in order to calculate the total number of point of each team. After that, you'll be able to select only the 1rst one. You can have a look on the 'table' PHP code where this treatment is already done (but in several PHP lines).

Jojo

jojo
French user of Free Joomsport
useravatar
Offline
793 Posts
Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic