Stupid Pop Up box

[Napster]

I am trying to make a pop up box with this code.

$sinfo = mysql_query("SELECT * FROM spells, uspells WHERE uspells.username='$username' AND uspells.id='spells.id'") or die(mysql_error());
echo "<center>Select a spell to cast.<br><br>
<select name='spellcast'>
<option value='none' checked>None";
while ($sinfo = mysql_fetch_array($sinfo)) {
echo "<option value='$sinfo[nos]'>$sinfo[nos]";
}  

echo "</select><br><br><br><br><br>";

and all that shows up is None as a aselection. I cant figure out why. Can you help.

[Napster]

I think the error is in the query so I will show you how the tables and all the info u need

uspells

username

A username

id

a spell id

spells

id

spell

id

nos

name of spell

And if you are wondering this is for my RPG site

[ahundiak]

Drop the quotes around this join condition.
uspells.id='spells.id'

And you should probably echo out the query just to make sure $username has a value.