Avoid recurring of Records in the code

Question

I am implementing Wordpress feature, viewing posts per Year and Month using PHP as

eg:

Press Releases

2013(4)
October(1)
Announcement1

But I am getting each records as repeated in the result. The code is as shown below:

$query = "SELECT * FROM edu_announcements WHERE status = '1' ORDER BY add_time asc";
$resultSet = mysql_query($query);
if (mysql_num_rows($resultSet))
{
    $newsArray = array();

    echo '<ul>' . PHP_EOL;
    echo '<li><strong>Press releases:</strong></li>' . PHP_EOL;                                            

    while ($newsResult = mysql_fetch_array($resultSet))
    { 
        $newDate =  $newsResult['add_time'] ;  
       $timePeriod =date("F Y", $newDate); 
        //$timePeriod = date('F  Y ',strtotime($newDate));
        $timePeriodY = date('Y',$newDate);
        $timePeriodM = date('F',$newDate);                                          

        if (!isset($newsArray[$timePeriod]))
        {
              $newsArray[$timePeriod] = array();
        }           
           $newsArray[$timePeriod][] = $newsResult;  

    }       

    foreach ($newsArray as $timePeriod => $newsItems)
    {
        $timePeriodY = date('Y',strtotime($timePeriod));
        echo '<li><strong>' . $timePeriodY . '</strong>' . PHP_EOL;  
        echo '<ul>' . PHP_EOL;

        //by month
        foreach ($newsArray as $timePeriod => $newsItems)
        {
            echo '<li><strong>' . $timePeriod . '</strong>' . PHP_EOL;  
            echo '<ul>' . PHP_EOL;                                

            //news items
            foreach ($newsItems as $item)
            {
                echo '<li>';
                echo '<a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php">'.$item["title"].'</a>';
                echo '</li>' . PHP_EOL;
            }     

            //end by month
            echo '</ul>' . PHP_EOL; 
            echo '</li>' . PHP_EOL;                   
        }

        //end by year
        echo '</ul>' . PHP_EOL; 
        echo '</li>' . PHP_EOL;                   
    }

    echo '<li>&nbsp;</li>' . PHP_EOL;   
    echo '</ul>' . PHP_EOL; 
} 
else {
    echo 'No announcements';
}

I am getting the result as repeated as shown below:

Array ( [July 2013] => Array ( [0] => Array ( [0] => 99 [id] => 99 [1] => sdfsdf [title] => sdfsdf [2] =>
 sdfsdfsdfc
[description] =>
 sdfsdfsdfc
[3] => [documents] => [4] => [photo1] => [5] => [photo2] => [6] => [photo3] => [7] => [photo4] => [8] => 1 [public_visibility] => 1 [9] => 0 [dept_visibility] => 0 [10] => 0 [depatment] => 0 [11] => 1373913000 [add_time] => 1373913000 [12] => 1 [status] => 1 [13] => sdfsdf [small_description] => sdfsdf ) [1] => Array ( [0] => 100 [id] => 100 [1] => sefsdfvsxdf [title] => sefsdfvsxdf [2] =>
 sdfsdfsd
[description] =>
 sdfsdfsd
[3] => [documents] => [4] => [photo1] => [5] => [photo2] => [6] => [photo3] => [7] => [photo4] => [8] => 1 [public_visibility] => 1 [9] => 0 [dept_visibility] => 0 [10] => 0 [depatment] => 0 [11] => 1374604200 [add_time] => 1374604200 [12] => 1 [status] => 1 [13] => sdfsefs [small_description] => sdfsefs ) )

I want distinct records from the table. Can anyone help me to solve this.

It sounds like you should use a Set or something that provides similar functionality. See http://stackoverflow.com/questions/8127384/built-in-support-for-sets-in-php It makes use of the `array_unique` function — Ron, Oct 10 '13 at 10:58
What should the output looks like? Add that to your question to make it clearer — Ron, Oct 10 '13 at 11:07
Off topic, but you should probably read [Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) — Spudley, Oct 10 '13 at 11:29

score 0 · Answer 1 · answered Oct 10 '13 at 12:28

If you mean why are you getting the parts of each record duplicated, such as:

[0] => 99
[id] => 99

it is because mysql_fetch_array has a second option (beyond your $resultset), which defaults to int $result_type = MYSQL_BOTH.

The type of array that is to be fetched. It's a constant and can 
take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH.

If you must use the raw (and old) mysql functions (as others say, this is no longer good practice), then you will also want to probably add , MYSQL_ASSOC to the function call, and then deal only with the name of the columns - such as 'id', 'title' & 'description'. There may also be similar parameters to other DB access calls, though mostly they will use the MYSQL_ASSOC-style returns to have the column name by default.

score 0 · Accepted Answer · answered Oct 25 '13 at 04:37

I solved the answer by using the code as shown below:

       echo '<div id="news_events_section_wrapper">
            <div class="news_events_section">';

            $CURRENT_TIMESTAMP=time();
            $sqlstr=mysql_query("select * from nesote_edu_announcements where status=1");
            $count=mysql_num_rows($sqlstr);
            if($count!=0)
            {
            while($article=mysql_fetch_row($sqlstr))
            {
            $id=$article[0];
            $details= $article[2];
            $postedon=date("F j, Y",$article[11]);

            $olderpost=date("Y",$article[11]);

            $yearnoquery=mysql_query("select count(*) from nesote_edu_announcements where add_time <='$CURRENT_TIMESTAMP' and status=1 ");
            $resultq=mysql_fetch_row($yearnoquery);
            $numberofposts=$resultq[0];
            }

            echo "<a href=javascript:showmonths(".$id.") style=".'"'."text-decoration:none".'"><div>';
                echo $olderpost;echo '(';echo $numberofposts;echo ')';
                echo '</div>
                </a>';

                $monthqry=mysql_query("SELECT add_time,COUNT(id),id FROM nesote_edu_announcements WHERE status=1  AND (add_time <='$CURRENT_TIMESTAMP') AND FROM_UNIXTIME(add_time, '%Y')='$olderpost' GROUP BY FROM_UNIXTIME(add_time, '%M') ASC");
                while($month=mysql_fetch_row($monthqry))
                {
                    $monthsfordisplay=date("F",$month[0]);  

                    $months=date("m",$month[0]);

                    $monthnos=$month[1];
                    $artid=$month[2];

        echo  '<div id='.'"'."month_art".'"'." class=".'"'."month_"; echo $id.'">';

                    echo  '<a href="javascript:showdetails'.'('; echo $artid; echo ')">'; echo $monthsfordisplay;
           echo '('; echo $monthnos; echo ')</a></div>';
                    $smalldisquery=mysql_query("SELECT * FROM  nesote_edu_announcements WHERE FROM_UNIXTIME(add_time, '%m')='$months' AND add_time <='$CURRENT_TIMESTAMP' and status=1");
                    while($smalldisc=mysql_fetch_row($smalldisquery))
                    {
                        $articlemonthid=$smalldisc[0];
                        $disc=$smalldisc[1];

                echo '  <div style="display:none;" id="sub_str" class="smalldiscription_';echo $artid; echo '">
                    <a href='.'"index.php?page=events/announcementdetails/'; echo $articlemonthid; echo '"'.' style='.'"text-decoration:none;'.'">
                    <font color="#80000">'; 
                $message=substr($disc,0,30);

$message=$message."...";


                echo "* ".$message; echo "</font></a>";
                    echo "</div>";
           }
                }
            }
                echo "</div></div>";

This will show announcements in Year-Month basis.

Avoid recurring of Records in the code

2 Answers2