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

11 votes225 views5 answers
Php post form to self
PHP
0 vote202 views1 answer
How to hide tax details from woocommerce order emails
PHP
0 vote257 views1 answer
Disable wordpress editor - gutenberg on Post type post
PHP Wordpress
6 votes228 views3 answers
Php mkdir
PHP
0 vote223 views2 answers
Get page title, excerpt or content by Name of the Page
PHP
10 votes229 views6 answers
Laravel Pagination
PHP Laravel
1 vote234 views1 answer
Install php-mbstring in ubuntu
PHP
0 vote282 views2 answers
From user id to user role wordpress
PHP Wordpress
0 vote211 views1 answer
Lumen redirect in controller
PHP
12 votes226 views6 answers
Laravel json response
PHP