显示值而不是ID mysqli

Question

When I add $elan_category, I get category_id, instead category_title.

Tried to apply "left join" but no success. I have following tables in database:

function getElanDetail()
{
    global $con;

    if (isset($_GET['elan_id'])) {

        $elan_id = $_GET['elan_id'];
        $get_elan = "select * from elan where elan_id='$elan_id'";
        $run_elan = mysqli_query($con, $get_elan);

        while ($row_elan = mysqli_fetch_array($run_elan)) {

            $elan_id = $row_elan['elan_id'];
            $elan_category = $row_elan['elan_category'];
            $elan_title = $row_elan['elan_title'];
            $elan_description = $row_elan['elan_description'];
            $elan_image = $row_elan['elan_image'];
            $elan_contact = $row_elan['elan_contact'];

            echo "
                $elan_category //Getting ID of category instead Title :(
                $elan_title
                $elan_description
                $elan_image
                $elan_contact
";

        }
    }
}

Answer 1

With join you can do something like:

$elan_id = $_GET['elan_id'];
$get_elan = "SELECT * FROM `elan` 
    JOIN `categories` ON `categories`.category_id = `elan`.elan_category 
    WHERE `elan`.elan_id='$elan_id'";
$run_elan = mysqli_query($con, $get_elan);
while ($row_elan=mysqli_fetch_array($run_elan)){
    print_r($row_elan);
    // see the keys in $row_elan and use them accordingly
}

For subcategories try this query:

SELECT * FROM `elan` 
JOIN `categories` ON `categories`.category_id = `elan`.elan_category        
JOIN `subcategories` ON `subcategories`.subcategory_id = `elan`.elan_subcategory 
WHERE `elan`.elan_id='$elan_id'