[RESOLVED] Select MAX() question

[djalecc]

Hi Peeps, I'm back 😃

Could anyone help me overcome a slight problem I now have with this line of code....

$sql="select max(d18) from tablename";

When I run this in phpMyAdmin, it returns 9990, yet there is an entry in d18 of 10000.

After I've selected max(d18) I add 10 to it, then create another entry in the database as the new number (d18+10)

So if d18 was 9990 the new database entry would be 10000, but the next time this happens, it should be 10010, yet it keeps it at 10000 so I get dups which is now messing up my system!

anyone know a cure for this?

Thank you 😃

[subwayman]

what type of field is d18?

[djalecc]

d18 was a text field, but I have just resolved this in the past 5 minutes by making it a INT(11) field. Thanks for the input tho, that was doing my head in !