[SOLVED] Mysql MIN

[Nandini]

Hi

I have a mysql database table astaccount. In that there is a field named as accountcode.

In database field accountcode values are 9001,9003,9000,58469.

In those values i want minimum value. For this i am using MIN function. But it is showing 58469 is minimum and 9003 is maximum . But i want 58469 as maximum and 9000 is minimum. here is my code.

<?

$least=mysql_query("select MIN(accountcode) as num from astaccount");

$row=mysql_fetch_array($least);

$lnumber=$row['num'];

echo $lnumber;

?>

[Lamez]

always use the long tags <?php

[Nandini]

If i am using the long tags its working fine?

[Lamez]

That is not what I am saying, but sometimes when you code a new page using short tags, you might run into some problems. Also could you post the error message you are getting, if any. If not add or die.

[Nandini]

yaaa you are correct!

[Lamez]

Woot! Topic Solved? If so click the "Topic Solved" button!

[Nandini]

Ok this is my backend server problem. i will solve this problem by taking help of my administrator.

Thanx for every cooperation.