problem with max()

webtuto · 11-03-2008, 12:10 PM

hey i want choose 5 users whos gain the max points and ive made this code

PHP Code:


			
          $val = mysql_query("SELECT max(point) FROM `points`")or die(mysql_error());

          while($able = mysql_fetch_array($val))

          {

          echo $able['MAX(point)']."<br />";

          }

BUT IT GIVE IS BLANK PAGE :s
is there any solutions thanks

Schroder · 11-03-2008, 12:40 PM

I think the problem is that the variables are case sensitive. So changing the first instance to uppercase should fix the problem.

PHP Code:


			
          $val = mysql_query("SELECT MAX(point) FROM `points`")or die(mysql_error());
          while($able = mysql_fetch_array($val))
          {
          echo $able['MAX(point)']."<br />";
          }

webtuto · 11-03-2008, 01:08 PM

i used ur code and it douesnt give me the max number :s

Schroder · 11-03-2008, 01:17 PM

Does it still give you the blank page, or is it giving you the wrong number?

I also wanted to confirm, is 'point' a field in your 'points' table?

webtuto · 11-03-2008, 01:18 PM

it give me the wrong number

yes point is a field in my points table

Schroder · 11-03-2008, 01:25 PM

Hmm... are you wanting to show the highest number that's in the point field or something else? If it's something else can you give some more information?

Thanks! =D

webtuto · 11-03-2008, 03:57 PM

yes im trying to get the highest number on the point field

DeMo · 11-03-2008, 05:26 PM

POINT is a undocumented (?) data type in MySQL.

Try this:

PHP Code:


			
$val = mysql_query("SELECT MAX(`point`) AS maxpoint FROM `points`");

while ($able = mysql_fetch_array($val))

    echo $able['maxpoint'] . "<br />";

Or an alternative would be this query:

PHP Code:


			
"SELECT `point` AS maxpoint FROM `points` ORDER BY `point` DESC LIMIT 1"

webtuto · 11-03-2008, 07:10 PM

ive tryied both ways but no results [ blank page ]

Schroder · 11-07-2008, 03:03 PM

Hmmm... wouldn't it return an error if it was trying to use the data type instead of the field name?

Would it be possible to get a SQL dump of what you currently have,or the structure + something that is similar?