string ID Number Increment

[ZainabJuma]

hello for everybody i have ID number which is string and i went to do query for maximam ID but it was not come pleas help me

[poojavb]

is the value coming from database??? where are u saving the maximum number???

if the value is coming from database use a select query

select max(columnname) from tablename 'columnname shud be the one which will be unique and incrementing

after that whatever value u will get convert it to Integer and increment by 1 and save it in the database

[ZainabJuma]

it well come if i set my ID text in database

[artemix22]

why don't you make it number such as integer? it will more easy if you use select max

[Jx_Man]

post a couple ID examples..

[poojavb]

It will be good if ur id in the database had the datatyoe as Integer coz it will help u in incrementing correctly...if u take it as text then u may face some issues while incrementing...