显示名称而不是另一个表中的ID

Question

I'm facing a problem to display a name on a table, only the id is displayed I have tried some inner join queries without luck i got 2 tables

Table 1 = empresas

Here is where all the data lives:

the number 9 in u_tip corresponds to the ID of the data that is in tipoempresas table

Table 2 = tipoempresas

I want to display the name of the type not the ID

I'm using this code to display the data in a html table

$result = mysqli_query($conn,"SELECT * FROM empresas");


$i = 0;
while($row = $result->fetch_assoc())
{
echo "<tr>";
foreach ($row as $value) {
  echo "<td>" . $value . "</td>";
}
echo "</tr>";

Answer 1

You are already there you just need to use join statement and specify the column you want to display

$result = mysqli_query($conn,"SELECT * FROM empresas AS e INNER JOIN tipoempresas AS t ON t.id = e.u_tip");


$i = 0;
while($row = $result->fetch_assoc())
{
echo "<tr>";
foreach ($row as $value) {
 echo "<td>" . $value['Nombre'] . "</td>"; //SPECIFY THE COLUMN YOU WANT TO DISPLAY
}
echo "</tr>";