[PHP]MySQL Query help

Ok, so I have my simple little query:

PHP Code:

---

SELECT JobID FROM Characters order by Level DESC LIMIT 10 


---

But, the job id's are numbers, e.g. 15, 45, 145, etc..., so it will only output numbers.

How would I make it say, for example, if the JobID is 15 make it say TrojanMaster?

Thanks

PHP Code:

---

$result = mysql_query("SELECT `JobId` FROM `Characters` ORDER BY `Level` DESC LIMIT 10");

$row = mysql_fetch_assoc( $result ); //personally like this more then _array

if ($row['JobId'] == 15) //If its 15
{
echo 'TrojanMaster';
} else if ($row['JobId'] == 45)
{
echo 'Next Class.';
}
//Keep adding else if until max. 


---

Something like that

Thanks, I'll try that.

Or you could make another MySQL Table, say something like JobNames, with ID + Name field, then just do

PHP Code:

---

"SELECT `Name` FROM `JobNames` WHERE `JobID` = '" . $row['JobId'] . "' LIMIT 1" 


---

That way you don't need to have a big ol' If statement

Also i'd use a switch statement, rather than an if

PHP Code:

---

switch ($row['JobId'])
{
   case 1:
            echo 'Name';
            break;
  case 2:
           echo 'Name2';
           break;
  default:
           echo 'Invalid Job!';
           break;
} 


---

I dont know cases that much in PHP..
I do know em in SCAR (delphi+pascal) ;)

Code:

---

//E.X:

case random(3) of //selects a random one of those.
0 := 'Yay';
1 := 'I know';
2 := 'cases in SCAR!';
end;

---

@Above:
Translated into php:

PHP Code:

---

<?php
switch(rand(1,3)){
    case 1:
        echo "1";
    break;
    case 2:
        echo "2";
    break;
    case 3:
        echo "3";
    break;
}
?>

---