Finding last entry

[savagenoob]

My query is not finding the last recieptnum entry, it is finding the number 9 everytime for some odd reason. Im trying to incrementally increase this each time a reciept is created.

 

$getreceiptnum = mysql_query("SELECT receiptnum FROM accounting WHERE agency = '$agency' ORDER BY receiptnum DESC LIMIT 1") or die(mysql_error());
        $recieptarray = mysql_fetch_array($getreceiptnum);
        $recieptnum = $recieptarray['receiptnum'];
        echo $recieptnum;

[Pikachu2000]

And 9 isn't the highest number in that field where agency = $agency, correct?

[savagenoob]

Right, actually it should be 22.

[savagenoob]

I changed it to

 

$recquery = mysql_query("SELECT * FROM accounting WHERE agency = '$agency' ORDER BY ID DESC LIMIT 1");
    $receiptq = mysql_fetch_array($recquery);
    $lastrec = $receiptq['receiptnum'];
    $recnum = $lastrec + 1;

and now its working. freaking wierd.

[chintansshah]

In mysql, use max() function to get highest value of particular column.

 

This is the way you can optimise your query also.

 

$getreceiptnum = mysql_query("SELECT max(receiptnum) FROM accounting WHERE agency = '$agency' ") or die(mysql_error());

[savagenoob]

Dang, thats awesome, thanks buddy.

[sasa]

why is field receiptnum type varchar if you put number in it?