Hi
I'm working on a basic bug tracking system for my school's website. However, running into a small problem with displaying a list of smods and admins.
This is my query:
SELECT * FROM ******.issues LEFT JOIN *******.users ON ******.issues.uid<>*******.users.uid OR ******.issues.uid=*******.users.uid WHERE *******.users.is_smod='1' OR *******.users.is_admin='1'
where the ****** represents the snipped table names. However, instead of just showing the username once, it displays the name twice.
For example, if there is one admin and one mod, with a username of admin and smod_test respectively, the drop down would do this:
Nobody
admin
admin
smod_test
smod_test
Any suggestions??
