hi ,
i have to make a web page to insert ward names of a city, if user adds new ward then a 8 digit ward no. shud be generated automatically which represents uniquely the distric, and state of the ward, for examle "wardname hajratgang ,wardNo.= UP320001 ", here wardNo. discribes about the ward (up=state code, 32=city code, , 001=wardno.),
in similar manner if user adds a city the 4 digit city code is also auto generated UP32 for lko UP33 for Raibareli and etc
so my problem is
1. how many tables i have to make
2. how to design tables and link them to get the autogenerate unique codes for citys(4 digits) and wards(8 digits)
plz help me
dispicable0me 0 Newbie Poster

LastMitch
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.