get last enterd value

saifullah khan

15y1.9k.NET

hello!
i have a table named schoolentry. it contain the following cols
name,subject, course.
there is a dropdown. there are 26 names in the dropdown. data is being entered in the database table from some other web page. now i want that when i select an element from dropdown and click on button it shows me the last entered close value of that name from the database. can some body tell me how is it possible?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
I think that what you are describing is often called a master-detail. I tried to search for articles in this web site and there probably is at least one article but it is not as easy to find as it should be. So try a search such as this. The following are among the results and hopefully they are relevant to what you are doing.
0
Javeed M Shaikh15y ago
A rowid is a pseudo column that uniquely identifies a row within a table and that is not you have to create on a table. This column exists with every table.

Please do not forget to mark "Accepted Answer"
0
Jean Paul15y ago
Hello Mr. Khan,

If your table contains the Id column then solution of Mr. Javeed would be an appropriate one.

Otherwise, I believe your table do not have the id column or any lastUpdatedTime column

select close, identity(int, 1,1) as Id into #temp from dailychange where symbol='GOLDEX'

select close from #temp where Id = (select (max(id)) from #t3)

drop table #temp

-- I believe this will work for you, but not the best way for achieving it. (Prefer: auto number id column for all tables)
0
Javeed M Shaikh15y ago
try this (assuming Oracle database):

select close from dailychange where rowid = (select max(rowid) from dailychange where symbol = "yoursymbol");

Please do not forget to mark "Accepted Answer"
0