Concatenate same array(number) from database

Question

It's a bit hard to explain here but I'll try my best to include all related information. You can ask me if you don't understand.

Above is the data I got and I wish to combine the same number (e.g 2016) to be displayed as shown below.

This is my code.

<?php
    $years = mysql_query("SELECT DISTINCT YEAR(event_date) as years, DATE_FORMAT(event_date,'%b') as months from news WHERE status<>'deleted' and status<>'draft' ORDER BY years DESC");

    while($page=mysql_fetch_array($years))
    { ?>
        <div class="date">
            <div class="year"><a href="<?php echo $sys_domain; ?>/news/index.php?year=<?php echo $page['years'] ?>&month=<?php echo $page['months'] ?>"><?php echo $page['years']; ?></a></div>

            <div class="month"><a href="<?php echo $sys_domain; ?>/news/index.php?year=<?php echo $page['years'] ?>&month=<?php echo $page['months'] ?>"><?php echo $page['months']; ?></a></div> 
        </div>
<?php } ?>

This is my database

May I know how to combine the year? I used "GROUP BY" but cannot, it hides the 2nd row of data. Or should I compare the value and combine it? But I have no idea how to do this. Please help, thank you.

Evelyn · Accepted Answer · 2016-01-13 09:42:26Z

1

Try this coding...

You are get result value and apply in your html content.

     <?php
        $years = mysql_query("SELECT DISTINCT YEAR(event_date) as years, DATE_FORMAT(event_date,'%b') as months from news");

        $result = array();

        while($page=mysql_fetch_array($years))
        {

            $year = $page['years']; 
            $month = $page['months'];

            $result[$year][] = $page['months'];

        }   

        if(isset($result)) {

        foreach($result as $key=>$year_array) { ?>

           <div class="year"><a href="<?php echo $sys_domain; ?>/news/index.php?year=<?php echo $key; ?>&month=<?php echo $month; ?>"><?php echo $key; ?></a></div>
           <?php 
           if(isset($year_array) && count($year_array) != 0) { 
                foreach($year_array as $month) { ?>

                     <div class="month"><a href="<?php echo $sys_domain; ?>/news/index.php?year=<?php echo $key; ?>&month=<?php echo $month; ?>"><?php echo $month; ?></a></div> 

            <?php } }
         } }   ?>

edited Jan 13, 2016 at 9:42

Evelyn

65610 silver badges32 bronze badges

answered Jan 13, 2016 at 4:34

msvairam

8725 silver badges12 bronze badges

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

9 Comments

Evelyn Over a year ago

I got the error message --> Function name must be a string

msvairam Over a year ago

what line display the error and post the updated coding ?

msvairam Over a year ago

sorry that is print_r($result); I have updated coding

Evelyn Over a year ago

Opps. I also didn't realized about the print_r. Now I got Array ( )

msvairam Over a year ago

check your query return result.

|

Sanjay Kumar N S · Accepted Answer · 2016-01-13 04:27:52Z

0

Update your code like this:

$years = mysql_query("SELECT YEAR(event_date) as years, GROUP_CONCAT(DATE_FORMAT(event_date,'%b') SEPARATOR '<br />') as months from news GROUP BY YEAR(event_date)");
while($page=mysql_fetch_array($years))
{ ?>
    <div class="year"><?php echo $page['years']; ?></div>
    <div class="month"><?php echo $page['months']; ?></div>  <?php 
} ?>

answered Jan 13, 2016 at 4:27

Sanjay Kumar N S

4,7595 gold badges25 silver badges41 bronze badges

2 Comments

Evelyn Over a year ago

So sorry because I didn't include my code completely. I need to filter the information by clicking the month. So my code is shown above(edited). When I click the month to filter, my URL reflected index.php?year=2016&month=Feb<br%20/>Jan

Sanjay Kumar N S Over a year ago

Check whether the code fetches the required format. Html you can bind According to your requirement

Collectives™ on Stack Overflow

Concatenate same array(number) from database

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related