Oops I knew that. (I've done this stuff over 100 times before lol)
Ok, here is my query and it still isnt working to how I want it to be, my main question is, sometimes there will not be a joining row in the "track" table to join up with the "sites" table. Is there a way to just say if there is then... kinda thing in a mysql query?
SELECT sites.ID, sites.TITLE, sites.URL, sites.MEMBER FROM sites,track WHERE sites.MEMBER != '$i[ID]' AND sites.MEMBER != '$ls' AND sites.AVLCREDITS = '1' AND sites.HOURSTOPPER != '$hour' AND sites.APPROVED = '1' AND sites.ACTIVE = '1' AND track.OWNER = sites.MEMBER AND track.MEMBER != '$i[ID]' AND track.DATE != '$gdade' GROUP BY (sites.MEMBER) ORDER BY RAND() LIMIT 20
Because in a certain case it will not work, but if I remove the...
AND track.OWNER = sites.MEMBER AND track.MEMBER != '$i[ID]' AND track.DATE != '$gdade'
it will work due the fact that there was no joining row in the track table.
Any input is greatly appreciated...