I have a list of entries from users and want mysql to only display entries that are unique.
The mysql statement is as follows
SELECT DISTINCT bids FROM `tbl_bids` ORDER BY `bids` ASC
On running the query it is still displaying items that appear more than once.
a table of data looks something like this
id user_id bids
1 1 0.1
2 1 0.2
3 1 0.3
4 2 0.1
5 2 0.2
Im wanting the output to show me, as seen in this table, the value of 0.3, but its listing everything.