Database error for my query

[MyPornLife.info]

hey i used this query but its showing error

$db->query_read("SELECT * FROM " . TABLE_PREFIX . "userdata AS userdata LEFT JOIN " . TABLE_PREFIX . "userid AS userid WHERE userdata.xID = userid.xID ORDER BY userdata.time DESC");


my ultimate goal is: first collect xID from table userid then collect all from userdata where xID is those collected xID

plz help me

[Lynne]

It really helps to know what the exact error is. You need to LEFT JOIN ON something.

$db->query_read("SELECT * FROM " . TABLE_PREFIX . "userdata AS userdata
LEFT JOIN " . TABLE_PREFIX . "userid AS userid ON (userdata.xID = userid.xID)
ORDER BY userdata.time DESC");