Log in or Sign up

PLease help with this

Discussion in 'PHP' started by lowridertj, Apr 29, 2007.

Thread Status:: Not open for further replies.

lowridertj Well-Known Member

Messages:

2,882

Likes Received:

40

Best Answers:

0

Trophy Points:

195

#1

I am trying to add areas of a table together to get top standings please take a look and make some suggestions.

$locals = mysql_query("SELECT id,
username,
goldglock,
silverglock,
bronzeglock,
email FROM $tab[user] WHERE
goldglock>=1 AND
silverglock>=1 AND
bronzeglock>=1
ORDER BY
goldglock+silverglock+bronzeglock+goldfree+silverfree+bronzefree
DESC;");
$rank = 0;
while ($local = mysql_fetch_array($locals))
{
$total = $local['goldglock']+
$local['silverglock']+
$local['bronzeglock']+
$local['goldfree']+
$local['silverfreek']+
$local['bronzefree'];
$rank++;
echo $local['username']. ' -with- ' .$total.' medals<br />';
Click to expand...

Thanks in advance.
TJ

lowridertj, Apr 29, 2007 IP
lowridertj Well-Known Member

Messages:

2,882

Likes Received:

40

Best Answers:

0

Trophy Points:

195

#2

Fixed but thanks....

I had forgot to add goldfree, silverfree, bronzefree to the above area

$locals = mysql_query("SELECT id,
username,
goldglock,
silverglock,
bronzeglock,

lowridertj, Apr 29, 2007 IP

(You must log in or sign up to reply here.)

Thread Status:: Not open for further replies.