Expand|Select|Wrap|Line Numbers
- $query = "SELECT DISTINCT username,num FROM user ORDER BY num DESC LIMIT 5";
- $result = mysql_query ($query) or die('query error');
- while( $line = mysql_fetch_assoc($result)){
- $um = $line[username];
- $nm = $line[num];
- echo "name:$um";
- if($nm <= 50){
- echo "Position: president";
- }else if($nm <= 40){
- echo "Position: vice";
- }else if($nm <= 30){
- echo "Position: manager";
- }else if($nm <= 20){
- echo "Position: marketer";
- }else if($nm <= 10){
- echo "Position: staff";
- }