472,143 Members | 1,557 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

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..............

Jan 11 '07 #1
1 1379
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.