Hi, can anyone give me a idea on how, to create a AUTO GENERATED ID,

example is.

SCHOOLNAME001 something like this, how may i be able to create this kind? in which the 1 will autoincrement after every new students will be enrolled...

Just use an auto increment column in your table. You can prepend/append anything you like in your select query, or afterward in PHP.

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.