Get name of join by id php

$sql=" SELECT  firm.`name` ,`address_physical_line_1` , `fax_1` , `phone_1` 
       FROM    contactdetails 
       JOIN    firm ON contactdetails.fk_firm_id = firm.id
       WHERE   contactdetails.fk_firm_id = '$id'
     ";

$result = mysql_query($sql);

Source: stackoverflow.com

Similar codes

0 vote316 views1 answer
Adding field to array on condition laravel
PHP
0 vote254 views1 answer
Get category name form single post wordpress
PHP
14 votes286 views6 answers
Install php 8 ubuntu
PHP
1 vote342 views2 answers
Get unique values in laravel
PHP Laravel
0 vote270 views1 answer
Call a blade from a blade in laravel 8
PHP
1 vote379 views1 answer
$posts- links() laravel design error
PHP Laravel
4 votes294 views1 answer
Php get array average
PHP
0 vote284 views1 answer
Retirrar ultimo caracter php
PHP
0 vote367 views1 answer
Laravel make:action
PHP Laravel
3 votes289 views2 answers
In arrray php
PHP