I have a table with an Id, how can I know the last Id num there is?
if your ID field is an autonumber... you can use MAX(ID) in your SQL statement.....<BR><BR>select max(ID) AS lastID from ................
... wrote more than I did!
how would he find out the last record if his ID field was a random number instead. I have never come across that problem. You might have a good way of solving that situation
... a create date field. And then, or by that field in DESC order:<BR><BR>SELECT TOP 1 idField<BR>FROM theTable<BR>ORDER BY createDateField DESC
thanks , how do write it on html page