[Linden]

Now everything is how I want, I just need a little more help

I want to arrange the info by adding 3 tables together. I've tried:

$honor1 = $row['honorPoints']+$row['honorToday']+$row['honorYesterday'];
$result = mysql_query("SELECT * FROM `characters` ORDER BY '$honor1' DESC LIMIT 3,47");

but it didn't work . Any Ideas?

Thanks =].

--Linden

[Advertisements]

I'm not a PHP/MySQL expert but If "honorPoints","honorToday", and"honorYesterday" are separate tables with their own fields then you would need to use some "INNER JOIN" statements. If they are fields within the "characters" table then you could try something like this:

$result = mysql_query("SELECT * FROM `characters` ORDER BY honorPoints DESC, honorToday DESC, honorYesterday DESC LIMIT 3,47");

[gunner12]

I'm not a PHP/MySQL expert but If "honorPoints","honorToday", and"honorYesterday" are separate tables with their own fields then you would need to use some "INNER JOIN" statements. If they are fields within the "characters" table then you could try something like this:

$result = mysql_query("SELECT * FROM `characters` ORDER BY honorPoints DESC, honorToday DESC, honorYesterday DESC LIMIT 3,47");