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)
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