从查询输出中选择第一行因为名称相同或将其设置为变量名称

Question

I use php-mysql

this is my output table on query because I use LEFT JOIN and have a null value Query = "Select * from table LEFT JOIN table2 ON table.ID=table2.ID"

and the ouput is

ID | ID   |
1  | NULL |

and if I get the datas from $row['id] using mysqli_fetch the thing that returns to me is NULL or "" and what I wanted to get the value is = 1

and I'm thinking that I'll just set the table.ID into variable but I don't know how

Answer 1

You should use column aliases for the id column in the first table from the id column in the second table:

select table.id as id1, 
       table2.id as id2
from table 
    left join table2 on table.ID=table2.ID

Then you can use the column alias in your php code to access that particular value.