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

Member Avatar for LastMitch

@dispicable0me

how to get id form parent table and use it into a child table for

Can you post the code of what you have so far?

I don't feel like guess what code you are using.

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.