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 vote98 views1 answer
Laravel create project with auth 2021
PHP
-2 votes96 views1 answer
How to redirect to another page in php after submit
PHP
0 vote107 views1 answer
How to make custom validator in laravel
PHP Laravel
0 vote150 views1 answer
Laravel rule unique where
PHP Laravel
0 vote166 views1 answer
String length laravel validation
PHP Laravel
0 vote107 views1 answer
Php datetime sub minutes
PHP
7 votes97 views1 answer
Join 2 tables laravel
PHP
0 vote127 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
0 vote61 views1 answer
How to add a css class to login page in wordpress
PHP Wordpress
1 vote104 views1 answer
E: Unable to locate package php7.2-mbstring
PHP