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

8 votes333 views1 answer
Laravel validation string type
PHP Laravel
0 vote326 views1 answer
Seeder name singular or plural laravel
PHP Laravel
0 vote384 views1 answer
Comment supprimer le fil d’Ariane WooCommerce dans WordPress
PHP
0 vote310 views1 answer
Laravel get current domain
PHP
0 vote269 views1 answer
Php remove line starting with
PHP
8 votes329 views1 answer
How to list out routes
PHP
18 votes336 views2 answers
Reload page in php
PHP
13 votes331 views3 answers
Laravel string
PHP Laravel
0 vote451 views2 answers
Drupal set message
PHP Drupal
0 vote370 views1 answer
Can we use 2 select in a query laravel
PHP Laravel