Query is acting strange

I am trying to display the results from a mysql table

Heres the query which should display the results

SELECT contents.entity_id, contents.entity_type, contents.rack_id, contents.entity_x_pos, contents.entity_y_pos, contents.rack_id, contents.entity_width, contents.entity_height, contents.entity_title, contents.enabled, racks.title, racks.enabled FROM contents INNER JOIN racks ON racks.rack_id = contents.rack_id WHERE contents.location = 'Comms Room' AND (racks.enabled = 1 OR contents.enabled = 1)

which produces,


why does it produce 2 of every rack?
If I want it to display only each unique rack should I use UNIQUE()?

nvm, my table was duplicated

you should still try to use UNIQUE() on it

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.