Help Meh Plz!!!

houser

Okay, I have two mysql tables. Users, and Ranks.

In my ranks table, I have rankID, and rank. The rankID corresponds to a rank.

In my users table, there is a rankID column (references the ranks table)

Now I am connecting to the users table, and pulling out all the information, and am printing it in a table, using the following:

<?php
$connection = mysql_connect("localhost" , "root" ,"")
or die("cannot make connection");
$db = mysql_select_db("db")
or die("cannot find database");
$sql_query = "SELECT * FROM users ORDER BY rankID desc";
$result = mysql_query("$sql_query");
?>

<?php
while ($rows = mysql_fetch_row($result))
{
?>

<?php } ?>

Thats what I have now, and it works, but instead of RANK!!, I want it to display the value "rank" in the "ranks" table.. How do i do it?!?!

THANK YUOU I LOVE YOU!

mahers

Give this a try.

$sql_query = "SELECT users.*, ranks.rank FROM users LEFT JOIN ranks ON users.rankID = ranks.rankID ORDER BY users.rankID DESC";

houser

Now how do i print it, i didnt get any errors.

<?php echo "print my rank value" ?>

whats "print my rank value" ??

mahers

It will depend on the number of fields in your users table. "my rank value" will be the last field of the database. Try echoing the $row vars e.g.

echo $row[0]."<br>";
echo $row[1]."<br>";
echo $row[2]."<br>";
// etc

Or you could try using the print_r($row) function in the while loop.

houser

that worked!

but i cant print the rank??

there are 6 colums in users, and 2 in ranks. i want the second column in ranks to print...so which

<?php echo $rows[??]; ?>

mahers

I think its.

$row[6];

houser

that worked,

and from now until the end of days, you shall be known as

The Man.