+ 2 tal

pixpoint og sourcepoint

even

pixpoint+sourcepoint

disky vis hele koden, jeg er elendig til SQL sætninger

Har forsøgt mig på denne her måde:

$query = mysql_query(\"SELECT users.username, SUM(pix.point) AS pixpoint, SUM(source.point) AS sourcepoint, (sourcepoint + pixpoint) AS ialt FROM users LEFT JOIN pix ON users.username=pix.udgiver LEFT JOIN source ON users.username=source.udgiver GROUP BY users.username ORDER BY $sort DESC LIMIT $start$limit\") or die (mysql_error());

Men så siger den: Unknown column \'sourcepoint\' in \'field list\'

Hmm... Det kan være, at du ikke kan bruge aliases der.
(SUM(source.point) + SUM(pix.point)) AS ialt

myplace: Bingo igen :) du tager alle mine point !