how to select latest updation using MYSQL

[sonasiva]

Hai .
iam doing my project(website) using ASP

I have data in database as like as follows

NO Name Companyname Shares Date
1 anish xxx 5000 5/1/2007
2 sanjai zzz 1000 10/1/2007
3 anish xxx 10000 10/1/2007
4 anish xxx 50000 11/1/2007
5 anish zzz 5000 11/1/2007

Every week i will update my dtabase so I need to display latest updated details of a name when i click the "name" link in my web page.This what i have to do

My display output should be

NO Name Companyname Shares Date
1 anish xxx 50000 11/1/2007
(latest data of anish for xxx company)


my code is as follows
my_SQL = "SELECT * FROM [data]"_
&"where name='"&request.querystring("name")&"'"&" order by date ()"

this code giving output of all records which i updated for a "name"


please help me to finish my project..............

Regards
sona

[ronverdonk]

This is about processing and displaying the MySQL result set in ASP. You already have the SQL statement, so you need help with the ASP code.

Therefore I will transfer this thread to the ASP forum. Good luck.

Ronald :cool: