Query with GROUP_CONCAT not working with PHP

Question

I am trying to display certain values through GROUP_CONCAT, and GROUP BY, yet only the groups are showing when I test it out, and the other values don't.

function events_calendar() {
     global $connection;
     mysqli_select_db($connection);
     $query = ("SELECT month, GROUP_CONCAT(start_date) as data FROM events GROUP BY month");
     $result = $connection->query($query);
     $str = "";
     while ($row = $result->fetch_assoc()) {
         echo $row['month'];
         echo $row['start_date'];
     }
     return $str;
}

The month values show up, but the start_date values don't.

Gordon Linoff · Accepted Answer · 2018-04-05 20:09:22Z

3

The problem is the PHP. Try replacing:

     echo $row['start_date'];

with:

     echo $row['data'];

You need to use the column alias that you assigned in the SELECT.

answered Apr 5, 2018 at 20:09

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

1 Comment

Juan Carlos Oropeza Over a year ago

Sorry my bad. I change the alias when answering his other question.

Collectives™ on Stack Overflow

Query with GROUP_CONCAT not working with PHP

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related