1 query select all 2 selects 1 need help

Paragon

[FONT=arial]Im not sure the exact reason, but this only selects 1 user. I want to select all in the database and display them. [/FONT]

<?	
include("accesscontrol.php");
include('../config.php');
include('header.php'); 
if($editpermission != "true"){ echo "You do not have permission to edit entries.</div></div></body></html>"; }else{
?>
 <form action="<? echo $PHP_SELF ?>" method="POST">
<?
    mysql_pconnect("$host","$username","$userpass");
    mysql_select_db("$userdatabase");
    $result = mysql_query("SELECT * FROM $userprefix order by dlevel");
    while($r=mysql_fetch_array($result))
    {    

    $id=$r["id"];
    $userid=$r["userid"];
    $rank=$r["rank"];
    $dlevel=$r["dlevel"];
    if($rank="$rank")
    {
    	$result = mysql_query("SELECT * FROM $rankprefix WHERE rnum='$rank'");
    	    while($r=mysql_fetch_array($result))
    {
    	$rnum=$r["rnum"];
    	$rank=$r["rank"];
    ?>
    <div align="right">
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="75%">
    <tr>
      <td width="100%"><? echo $userid;?>  <input type="text" name="dlevel" value="<? echo $dlevel; ?>" size="6">  <? echo $rank; ?></td>
    <br />  <br />
  <? } } }?>  

   <input type="submit" name="editdlevel" value="Edit" />
</form>
   </tr>
  </table>
</div>
<?
if($editlevel=="Edit")
{
	$sql = "UPDATE $userprefix SET id='$id',userid='$userid',dlevel='$dlevel' WHERE id=$id";
        $result = mysql_query($sql);
        echo "Entry Updated </div></div></body></html>";
		exit;
    }
}
?>

OhLordy

<?    if($rank="$rank") ?>

this line is setting $rank to $rank. I'm not exactly sure what you want.

<?
$rank=="$rank" //will check for equality between $rank and $rank (will always evaluate to true)
$rank=="\$rank" //will check for equality between the contents of $rank and the string "$rank" (returns true if variable $rank contains string "$rank")
$rank="$rank" // the same as $rank=$rank (should always evaluate to true)
$rank="\$rank" //sets $rank to the string "$rank" (should always evaluate to true)
?>

Hope this helps
Rob

Paragon

Thanks, but im not really trying to figure out how to make rank =

these are my tables
$userprefix - id - rank - username
$rankprefix - id - rank - rnum

rnum gets saved in the $userprefix. Now im trying to just match up the rnum with the rank from the $rankprefix.

My problem is. I want to list all users in the database.

the rank number is pulled from the first query.

then in the 2nd query the ranks name is pulled.

rnum stands for rank number.

im just using the 2nd query to get the ranks name.

so really.

If I remove the 2nd query the whole user database is listed with the ranknumber next to it.

I just cant ever seem to get the right post across how ever I say somthing.