cuphongle
01-04-2007, 06:25 PM
Invalid SQL:
SELECT pm.*, pmtext.*
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 1
AND pmtext.dateline > 1167932901
AND pm.messageread = 0;
wat can be the problem? i get this when checking my pm and usercp
SELECT pm.*, pmtext.*
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 1
AND pmtext.dateline > 1167932901
AND pm.messageread = 0;
wat can be the problem? i get this when checking my pm and usercp