[SOLVED] getting from one table listing from another

[nathanmaxsonadil]

I know this is kinda crazy but I need it

I have one table that lists name's

and I have another table that has the name's and points

I want to know how to list the name's of the first table by the points of the second table

 

 

[Masna]

If the table that contains points also contains names, you should only need to work with one table.

 

SELECT `names` FROM `table` ORDER BY `points` DESC

[nathanmaxsonadil]

I have 2 table's because no all the names are going to be listed in the first table

[BlueSkyIS]

SELECT `names` FROM `table` WHERE `names` IN (SELECT `names` FROM `othertable`) ORDER BY `points` DESC

[nathanmaxsonadil]

thanks

[nathanmaxsonadil]

in phpmyadmin it works but in php it does not

here's my code

$sql = "SELECT `username` FROM `users` WHERE `username` IN (SELECT `need` FROM `tb`) ORDER BY `points` DESC";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
echo "<ul>";
while ($row = mysql_fetch_assoc($result)) {
echo "<li>{$row['need']}</li>";
}
echo "</ul>";
}

[Jessica]

What "does not work"? What are you expecting and what do you get?

[nathanmaxsonadil]

it only display an empty ul... but in phpmyadmin it display's the username....

[Illusion]

U didn't select the 'need' column in ur query .........how does $row['need']?