How can I make display weekly record?

[faiz2000]

Thank you MeTin I make table with 3 fields 1-ID 2-last Day 3-Info After
that I did what you tell me for SQL and info field it's added in the ASP page.
When I test it by this information below: id last Day info 1
06/03/2005 test1 2 27/02/2005 test2 3 28/02/2005 test3
Its give me test2, when I change date to 28/02/2005 the output it's the same?
Please your help? Regards,

[MeTin]

hello mate

iam a bit confused now ...so can u pls just tell me ur fields names and what
exactly wanna do (u wanna sort info from DB by) so i can try to give u
another example ..

"faiz2000" <webforumsuser@macromedia.com> wrote in message
news:cvurr2$ifa$1@forums.macromedia.com...

> Thank you MeTin I make table with 3 fields 1-ID 2-last Day 3-Info
> After
> that I did what you tell me for SQL and info field it's added in the ASP
> page.
> When I test it by this information below: id last Day info
> 1
> 06/03/2005 test1 2 27/02/2005 test2 3 28/02/2005
> test3
> Its give me test2, when I change date to 28/02/2005 the output it's the
> same?
> Please your help? Regards,
>