Avoiding duplicates of a specific column in database

Question

I have the following method for pulling out all the data from my database. However in my database there is a column called media_id. I want to make sure that it only fetches data where the media_id is unique. If there is a duplicate based on the media_id column, it just needs to pick the first one it runs into and disregard all the rest. Anyone have any suggestions how I do this? Any help is greatly appreciated.

public function getAllValuesFromOneTable($table1, $fromDate, $toDate) {
    try {
        $statement = $this->prepareStatement("SELECT * FROM $table1 WHERE date_of_post >= '$fromDate' AND date_of_post <= '$toDate'");
        $statement->execute();
        $test = $statement->fetchAll(PDO::FETCH_ASSOC);
        return $test;
    } catch (Exception $e) {

        echo "error: " . $e->getMessage();
    }
}

PSVSupporter · Accepted Answer · 2015-11-25 15:31:01Z

1

Use

select distinct media_id

(and if the filename is in a separate field, add this column to the query) This way if the table would be

It only returns:

answered Nov 25, 2015 at 15:31

PSVSupporter

3483 silver badges16 bronze badges

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

Comments

Hassan Al Bourji · Accepted Answer · 2015-11-25 15:27:49Z

0

you can group your results in sql search by media_id

SELECT * FROM $table1 WHERE date_of_post >= '$fromDate' AND date_of_post <= '$toDate' group by media_id

answered Nov 25, 2015 at 15:27

Hassan Al Bourji

1951 silver badge13 bronze badges

Collectives™ on Stack Overflow

Avoiding duplicates of a specific column in database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related