|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
August 14th, 2003, 08:30 AM
|
|||
|
|||
Sorting an Array
Hi, i need some help with the following:
-I want to select 3 columns from a table, i.e. rank, name and team. -I would then like to make an array something like this: 'rank, name, team' for each row. -So the output should look like: PHP Code:
- Before i output the results i want to multiply (rank x score) and then sort the the total in the array using the asort() command. How do i do this?
__________________
regards, Fulton Last edited by DDDooGGG : August 14th, 2003 at 08:35 AM.
|
|
#2
August 14th, 2003, 11:17 AM
|
||||
|
||||
|
Where's score coming from and what do you mean when you say you want to sort the total of the array?
You might try doing the math within your query, something like the following: Code:
SELECT rank, name, team, (rank * score) as adjustment FROM table ORDER BY adjustment ASC
|
|
| Viewing: Dev Articles Community Forums > Programming > General Programming Help > Sorting an Array |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
