Hi,

Just a simple one!

I have written a news script which works perfectly, hurray! Anyway, I use MAX() to select the lestest news article from the MySQL database. This workd fine until you come to the number 9. MAX() doesn't like different number legths. I have come up with a solution but don't know how to do it.

I want to turn 1 into a 5 digit number... eg. 00001 and 2 to 00002 etc. So when it runs into double figures it will still be the same number length, eg. 00010, 000011 etc.

Hope you understand what I'm getting out and that someone can help me out with this one.

Many Thanks
Adam

I think you could use:

$str = sprintf("%05d", $mynumber);

and that should take mynumber and turn it into a 5 digit string.
See http://www.php.net/sprintf for more details on that function. It's similar to the C++ function is you know that.

Not sure if that helps. Might be smarter not to convert to string though, and simply find the maximum number using another method.

Edit:
Actually, now I think about it... I think your problem is the fact that you're passing strings to the function instead of ints. Maybe you could try typecasting your variables to ints, before passing them to MAX.

For example:
$var=(int)$var

I sorted the problem by changing the database...

I set the ID column to INT and UNSIGNED ZEROFILL in the attributes.

I think this is what you were getting at in your edit.

Thanks