Member Avatar for 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

  • 4 Contributors
  • 5 Replies
  • 122 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by poojavb
Member Avatar for 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

Edited by poojavb
Member Avatar for ZainabJuma

it well come if i set my ID text in database

Member Avatar for artemix22

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

Edited by artemix22
Member Avatar for Jx_Man

post a couple ID examples..

Member Avatar for 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...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.