Creating An Array Without Duplicates From A MySQL Result in PHP

Question

I am trying to do a select statement from my MySQL DB in PHP using PDO. I successfully create an array with the query results. But then, I want to filter out duplicate entries with the same date, thus creating an array of dates.

function grabUsefulDates() {
$sql = "SELECT DATETIME, pointcount FROM `fjbarrett`";
$sql_array = dbSelect($sql);
$datesarray = array();
$i = 0;
while($i < count($sql_array)) {
    if (count($datesarray) == 0) {
        $datesarray[] = datetimeConvertToDate($sql_array[$i]['DATETIME']);
        echo "rollone";
    } else {
        foreach ($datesarray as $f => $date) {
            if ($date !== datetimeConvertToDate($sql_array[$i]['DATETIME'])) {
                echo $date;
                echo " " . datetimeConvertToDate($sql_array[$i]['DATETIME']);
                echo "<br>";
                $datesarray[] = datetimeConvertToDate($sql_array[$i]['DATETIME']);
            }
        }
        }
        $i++;
    }
var_dump($datesarray);
}

This code will not run, but when I remove the "add to array" line within the foreach loop, it will run. Any suggestions?

Have you removed the "add to array" line from the post too? I see nothing resembling. — Gábor Bakos
– Gábor Bakos, Commented May 29, 2015 at 6:29

Manashvi Birla · Accepted Answer · 2015-05-29 06:28:21Z

3

Simply use this query :

SELECT DISTINCT DATETIME, pointcount FROM `fjbarrett`;

answered May 29, 2015 at 6:28

Manashvi Birla

2,8393 gold badges16 silver badges28 bronze badges

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

1 Comment

fjbarrett Over a year ago

Definitely helped. Had no idea about the DISTINCT function in MySQL. Thanks!

Collectives™ on Stack Overflow

Creating An Array Without Duplicates From A MySQL Result in PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related