I want to get data from 2 tables...easy! Works as it should.
Code:
SELECT mam01_user.*, (SELECT nick FROM mam01_nicks WHERE user = mam01_user.id ORDER BY id DESC LIMIT 1) AS player FROM mam01_user, mam01_nicks LIMIT 10
However, when I go to order it...I get 10 identical rows of information.
Code:
SELECT mam01_user.*, (SELECT nick FROM mam01_nicks WHERE user = mam01_user.id ORDER BY id DESC LIMIT 1) AS player FROM mam01_user, mam01_nicks ORDER BY mam01_user.lastseen DESC LIMIT 10
What am I doing wrong?