Ad:

MySQL Discussion Thread
Unsolved
Views: 1077

Permalink

Oct 2nd, 2009

retrieve the last record???

Expand Post »

How to write a query to retrieve the last record that is entered. ???

Similar Threads

To Search a record in datagridview in VB.NET
Why do incorrect value pairs still reflect a record? in MySQL
retrieving record based on date in VB.NET
retrieve record in Visual Basic 4 / 5 / 6
retrieving current record in database in Visual Basic 4 / 5 / 6

jrosh

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

140 posts
since Sep 2009

Permalink

Oct 2nd, 2009

Re: retrieve the last record???

I do not know if this can help you, but if you have a date field which you can order by desc, then you can use Top 1 something like this.

sql Syntax (Toggle Plain Text)
SELECT top 1 Field1
FROM table1
ORDER BY datefield desc
Select top 1 Field1
from table1
order by datefield desc

if you dont have a date maybe have a index field that is the easiest way to do that.
regards

jbisono

Reputation Points: 56

Solved Threads: 56

Posting Pro in Training

Offline

433 posts
since May 2009

Permalink

Oct 5th, 2009

-2

Re: retrieve the last record???

no u just have an id column that auto increments then ur like mysql_query("SELECT MAX(id) FROM table or something

SKANK!!!!!

Reputation Points: 15

Solved Threads: 7

Posting Pro in Training