JSON_ENCODE for two columns with same name in php

Question

my problem is i want to JSON_ENCODE the result of inner join query and the two columns i want to select have the same name so, the JSON object override one of them and carry only data for one column cause they have the same name,,this is my code till now.

 $query = "select faculty.NAME,sector.NAME from faculty inner join sector
        on faculty.SECTOR_ID=sector.ID";
$result = mysql_query($query);
while($r = mysql_fetch_assoc($result)) {
$rows[] = $r;
 }
 echo json_encode($rows);

how to do this without change the column name in the DataBase...

Filippos Karapetis · Accepted Answer · 2013-06-07 15:15:09Z

1

Try changing the output of your query:

select faculty.NAME AS facultyName,sector.NAME AS sectorName from faculty inner join sector
    on faculty.SECTOR_ID=sector.ID

answered Jun 7, 2013 at 15:15

Filippos Karapetis

5,20423 silver badges39 bronze badges

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

Comments

Prisoner · Accepted Answer · 2013-06-07 15:15:08Z

1

Using as:

select faculty.NAME as faculty_name, sector.NAME as sector_name from faculty inner join sector
    on faculty.SECTOR_ID=sector.ID

This will change your json values to something like:

{"faculty_name": "first", "sector_name": "second"}

so you will need to update your javascript.

answered Jun 7, 2013 at 15:15

Prisoner

27.7k11 gold badges78 silver badges104 bronze badges

Comments

Fabio · Accepted Answer · 2013-06-07 15:15:05Z

0

You can use ALIAS In your query so you will have different names for your columns

select faculty.NAME as faculty_name ,sector.NAME as sector_name

answered Jun 7, 2013 at 15:15

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Collectives™ on Stack Overflow

JSON_ENCODE for two columns with same name in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related