in php i insert some data into database. In database s_no automatic increase when any data instered.
I want to get that s_no. how do i get it.
newbie1234 -2 Newbie Poster
Squidge 101 Newbie Poster
in php i insert some data into database. In database s_no automatic increase when any data instered.
I want to get that s_no. how do i get it.
Newbie1234, can you show some code you are using? What is the naming in you db table?
YOu would get the s_no (assuming primary key?) in the exact manner as you would any other data from the database
Select s_no from 'table' where s_no = 'something'
newbie1234 -2 Newbie Poster
i am using trivial table. in this table s_no is auto increment field. Whenever i am inserting any data to table. This field automatic increse. Now whenever i am inserting in database i want to see what is s_no. So how can i retrive from table at the same time....
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.