[Resolved] Numerical Sequence

[baffled_in_UK]

Hi,

Can someone please tell me why a field (DEC 5,0) with a value of 300 in a table is considered less than a search value of 36

The search value is created like this :

$weight = number_format($weight, 0, '', '');

Am I formatting the number incorrectly? Is the numeric ordering in a MySQL table a bit quirky? Am I misunderstanding some basic mathematical rule?

Any help is appreciated.

Thanks

[Weedpacket]

By using number_format you're turning the number into a string; and by the lexicographical ordering of strings, "300" comes before "36".

If you're trying to use number_format to round $weight off, I suggest using [man]floor[/man] or [man]round[/man] or maybe [man]intval[/man] - those functions return numbers.