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.

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'

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