table joining to get output

Question

I am trying to get a result by joining two tables . but i am not getting proper result . can any one tell where i am wrong ?

here is my code

$sql = "SELECT merchant.name, keyword.name
FROM keyword 
INNER JOIN merchant
ON merchant.id=keyword.merchant_id";

And my table structurer is

keyword

1.name (keyword name)

2.merchant_id

merchant

1.id

2.name (merchant name)

the result sholud be like this

merchant name |||||| keyword name

and SQL fetch query is

while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) 
{

  echo "<tr><td>".$row['name']."</td><td>".$row['name']."</td>";

 }

But the output is

keyword name |||||| keyword name

only i am getting keyword name

can any one tell me where i am wrong . (sorry for my bad English)

echo "".$row['name']."".$row['name'].""; both are same variable — Shanu k k, Dec 13 '16 at 07:05

score 2 · Accepted Answer · edited May 23 '17 at 11:53

2

Dont use mysql use Mysqli

you could try

$sql = "SELECT merchant.name as mname, keyword.name as kname FROM keyword INNER JOIN merchant  ON merchant.id=keyword.merchant_id";

and

echo "<tr><td>".$row['mname']."</td><td>".$row['kname']."</td>";

edited May 23 '17 at 11:53

Community

1
1

answered Dec 13 '16 at 07:06

Afsar

3,104
2
25
35

score 1 · Answer 2 · answered Dec 13 '16 at 07:06

1

Try this

$sql = "SELECT merchant.name as m_name, keyword.name as a_name
    FROM keyword 
    INNER JOIN merchant
    ON merchant.id=keyword.merchant_id";

Then

while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) 
{

  echo "<tr><td>".$row['m_name']."</td><td>".$row['a_name']."</td>";

 }

answered Dec 13 '16 at 07:06

Shanu k k

1,235
2
18
43

this also help full :) – Trend Snaps Dec 13 '16 at 07:10

score 1 · Answer 3 · answered Dec 13 '16 at 07:08

The issue arises because you are having two column in the query with same name and second one overrides first. Try this:

$sql = "SELECT merchant.name as mer_name, keyword.name as k_name  // Aliasing for column names
FROM keyword 
INNER JOIN merchant
ON merchant.id=keyword.merchant_id";

and use it like:

$row['mer_name'], $row['k_name'];

table joining to get output

3 Answers3