Thanks for anyone that looked at this thread. After playing around with the code off and on, I was able to find a way to make them interchangeable with this:
<?php
$query = "SELECT users.username, users.access_level, users_access_level.access_name ".
"FROM users LEFT JOIN users_access_level ".
"ON users.access_level = users_access_level.access_level";
$result=mysqli_query($db,$query);
while ($row = mysqli_fetch_array($result))
{
echo "<tr><td>";
echo $row['username'];
echo "</td><td class='center'>";
echo $row['access_name'];
}
?>
If there is a better way to do this, I'd appreciate the guidance, but I do have a separate question. The reason I have it setup like this is I want to make a <select></select> option, that once the query is run, will automatically make the user's "access_name" the "selected" option by default when the page loads. I want to make it so I can change the user's access_level on the fly with a quick SQL update/delete query.
Thanks again!