Show rank name instead of rank id

[Proximity]

How can i display a rank name instead of the id of the rank

Like SELECT rank FROM users

SELECT name from ranks where id

or something like that?

 

[RastaLulz]

You'd want to use an INNER JOIN.

Something like this should do the trick:

SELECT users.name, ranks.name
FROM users
INNER JOIN ranks
ON ranks.id = users.rank

 

[Proximity]

So like

$rankg = mysql_fetch_array(mysql_query("SELECT '.$_SESSION['user']['id'].', ranks.name FROM users INNER JOIN ranks ON ranks.id = users.rank"));

 

[BIOS]

Add another column "title" to the ranks table, give each rank a title

SELECT r.title FROM ranks r LEFT JOIN users u on u.rank = r.id WHERE u.id = $_SESSION['user']['id']

 

[Proximity]

<div><img src="%www%/images/terms_icon.gif"> Rank: <b><?php echo $rankg; ?></b></div>
And
$rankg = mysql_fetch_array(mysql_query("SELECT r.title FROM ranks r LEFT JOIN users u on u.rank = r.id WHERE u.id = '".$_SESSION['user']['id']."'"));
it isn't working
 
It shows array

 

[BIOS]

<div><img src="%www%/images/terms_icon.gif"> Rank: <b><?php echo $rankg; ?></b></div>
And
$rankg = mysql_fetch_array(mysql_query("SELECT r.title FROM ranks r LEFT JOIN users u on u.rank = r.id WHERE u.id = '".$_SESSION['user']['id']."'"));
it isn't working
 
It shows array

Did you add the new column?

Also run the query in a SQL admin tool e.g. Navicat to see what result you get.

SELECT r.title FROM ranks r LEFT JOIN users u on u.rank = r.id WHERE u.id = '1';

 

[Proximity]

Yea it worked

 

[BIOS]

Yea it worked

If the query worked in the admin tool then it's something else on your side, check your PHP code etc.

 

[Proximity]

<div><img src="%www%/images/terms_icon.gif"> Rank: <b><?php echo $rankg; ?></b></div>
and

$rankg = mysql_fetch_array(mysql_query("SELECT r.title FROM ranks r LEFT JOIN users u on u.rank = r.id WHERE u.id = '".$_SESSION['user']['id']."'"));
$getstats = mysql_fetch_assoc(mysql_query("SELECT * FROM user_stats WHERE id = '".$_SESSION['user']['id']."'"));
$getLook = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id = '".$_SESSION['user']['id']."'"));
?>

that is the code

 

[Weasel]

Change mysql_fetch_array to mysql_fetch_assoc.

echo $rankg["title"];

 

[Brad]

I think this is what you're asking for?

$userinfo = mysql_query("SELECT id,username,rank FROM users WHERE username='" . $_SESSION['user']['username'] . "'");
$get2 = mysql_fetch_assoc($userinfo);

$getrank= mysql_query("SELECT id,rank FROM ranks WHERE id= "'.$get2['rank'].'");
$getr2 = mysql_fetch_assoc($getrank);

Then put
<?php echo $getr2['id']; ?> Where ever you want it to display?

 

[Proximity]

It had * because of the other things..

             <div><img src="%www%/images/icon_habbo_small.png"> User ID: <b><?php echo $getLook['id']; ?></b></div> 
               <div><img src="%www%/images/credits.png"> Credits: <b><?php echo $getLook['credits']; ?></b></div> 
               <div><img src="%www%/images/duckets.png"> Duckets: <b><?php echo $getLook['activity_points']; ?></b></div> 
               <div><img src="%www%/images/diamond.png"> Diamonds: <b><?php echo $getLook['seasonal_currency']; ?></b></div> 
               <div><img src="%www%/images/owner_icon.gif"> ROTW Points: <b><?php echo $getLook['ROTW_Points']; ?></b></div> 
               <div><img src="%www%/images/terms_icon.gif"> Rank: <b><?php echo $rankg; ?></b></div>