469,630 Members | 1,222 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,630 developers. It's quick & easy.

how to select latest updation using MYSQL

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
Jan 11 '07 #1
1 1321
ronverdonk
4,258 Expert 4TB
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:
Jan 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by kaptain kernel | last post: by
21 posts views Thread by John Fabiani | last post: by
4 posts views Thread by Mick White | last post: by
reply views Thread by Lakshmi Narayanan.R | last post: by
1 post views Thread by Babz | last post: by
1 post views Thread by siri11 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.