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

21 votes102 views6 answers
Change php version ubuntu
PHP
0 vote133 views1 answer
Woocommerce update_status() email
PHP
1 vote127 views1 answer
How to catch query exception in laravel 8
PHP Laravel
6 votes125 views1 answer
Join 2 tables laravel
PHP Laravel
0 vote119 views1 answer
Php force array keys trim
PHP
-1 vote120 views1 answer
Wordpress turn off php warnings
PHP
1 vote138 views4 answers
Laravel generate slug
PHP Laravel
0 vote104 views4 answers
Python to php
PHP
1 vote109 views1 answer
Php if no imagee exists
PHP
0 vote119 views1 answer
Php division without round
PHP