PHP display $rows from inner table

Question

Like on title... how to display row data from inner join table if name of the row are the same?? but data is diffrent?

$sql = "SELECT fv.name,fvcount.name,fvcount.datew,fvcount.u_uid 
        FROM fv 
        INNER JOIN fvcount ON fv.u_uid = fvcount.u_uid ";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)) {
   echo $row['u_uid'];
 }

Result will be printed, but on both table 1 of the rows name is like: name

So if i put

$row['name'];

i will have output of inner join table

How to get output from main table and inner joint table? I can't change name of the row...

Any clue?

fvcount.name AS name1, fv.name AS name2 then use name1 and name2. — AbraCadaver
– AbraCadaver, Commented Jan 9, 2019 at 20:28

Alex Howansky · Accepted Answer · 2019-01-09 20:28:57Z

4

The typical solution is to use column aliases. You can do something like:

SELECT fv.name AS fv_name, fvcount.name as fvcount_name, ...

And then use:

$row['fv_name']

Or:

$row['fvcount_name']

answered Jan 9, 2019 at 20:28

Alex Howansky

54.1k8 gold badges85 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP display $rows from inner table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related