Hi,
I'm new to databases & asp and am using dreamweaver mx 2004 (trial) to go about
making dynamic pages. I was wondering if anyone could help me with a problem
that I'm having, I would think its pretty easy to solve...
Basically what I want to do is to have webpage showing the top news stories of
the day with a limit of 3 database (ie news) entries per page. Obviously the
top stories will change day by day and I will be adding them to the database
via an asp form. This part is no problem. Where my problem arises is that if
I limit the repeat region asp command to 3 entries on the page, then the page
will only display the first 3 entries in the database and not the new entries
that I add. What I want to do is to replace the oldest news story (ie the
first in the database) with the newest (ie the last added to the database) and
show the newer news story on the webpage with the oldest entry being "bumped"
so to speak. However, I would like to keep the older news stories in the
database, just not have them on the website.
Does anyone know how I would go about this in dreamweaver or access? I would
have thought it would be as simple as to just sort them descending rather than
ascending but can't quite work out how to do this!!!
Any help would be greatly appreciated! :)
Rob F.