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

35 votes185 views2 answers
Program-generate-random-alphabets using php
PHP
0 vote174 views1 answer
Get user avatar wordpress
PHP
0 vote180 views2 answers
File_get_contents url fail
PHP
1 vote169 views1 answer
Grenerating random text color for text for image php
PHP
6 votes233 views1 answer
Laravel add attribute migration column
PHP Laravel
0 vote190 views3 answers
Slick slider and ACF Pro in WordPress
PHP Wordpress
3 votes200 views1 answer
Laravel mail and sms system
PHP Laravel
40 votes169 views2 answers
$dom->getElementById
PHP
0 vote194 views1 answer
Post request data not getting from guzzle laravel
PHP
1 vote199 views1 answer
How get the latest arraye value in laravel
PHP Laravel