| Author |
 Topic  |
|
CooLGiL
Junior Member
126 Posts |
 Posted - 24 April 2002 : 09:48:53
|
danm, its really imeditly.
hmmmm.
hmmmmm.
hmmmmmm.
well, any one else?
here is my problem:
im making a new program, in asp.
it will let you add news to a database without using any html or other scripting.
im going to finish and my problem is that when i add a news it become the oldest becse of the AutoNumber.
what i wanna do is to loop the "do while" so i can get the table opside i mean like that,
A: the problem:
ID
1
2
3
4
5
6
when i add news the news become 7
like this:
1
2
3
4
5
6
7
so when im showing the news the newwes became oldest!
i want it to show li that:
7
6
5
4
3
2
1
so the newest will really be the newest!
thanks all for your help..
|
 |
|
|
Bunce
New Member
Australia
84 Posts |
Posted - 25 April 2002 : 20:39:05
|
I must have missed something, but when you get the records from your table order them first.
SELECT Field1, Field2
FROM TableNname
ORDER BY Id DESC
Sorry if I'm stating the obvious but I've only read the last few posts.
Alternatively put your recordset into an array (getrows) and you can then do what you like with it.
Andrew
======================================================
There have been many, many forum posts made throughout the world...
This was one of them! |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 25 April 2002 : 21:10:43
|
Yeah I think we've been there and done that one already Bunce  , thanks for your input though, I'm still trying to recover my site from a server crash so haven't been able to get back to CooLGils problem at all.
If you'd like to send your page and database to this email address CooLGil, I can take a look at it today for you.
www.daoc-halo.com |
|
|
|
CooLGiL
Junior Member
126 Posts |
Posted - 26 April 2002 : 06:59:26
|
ok man, im sending. again
|
|
|
|
Topic |
|
Topic Locked
