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 vote311 views1 answer
"ajax": { "url": "<?php echo site_url('transaction/loadfirmwaterinfo')?>", "type": "POST", data: {x:x}, },
PHP
0 vote307 views1 answer
Cashier mollie
PHP
0 vote352 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
0 vote327 views1 answer
Laravel get limited character of string
PHP Laravel
6 votes363 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
4 votes308 views2 answers
Pass parameter to view laravel
PHP
0 vote331 views1 answer
Reply to wp_mail
PHP
41 votes373 views6 answers
Capitalize php
PHP
0 vote337 views1 answer
Laravel store multiple files
PHP Laravel
6 votes338 views1 answer
Qual é a melhor linguagem de programação para iniciantes
PHP