wanna highlight latest entry

[jackman]

Hi

I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this?
Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.

thanks and bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[higgins]

Try this code out

SELECT TOP 1 *
FROM <table>

UNION

SELECT *
FROM <table>
WHERE <id> <> (SELECT TOP 1 <id> FROM <table>)

hope that it work for u -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[acerman]

You can also try this if you don't have any preference to show details order by any other field

Select userId,userDetails from tableName orderby userId Desc

in this result the first entry is the newest one.
now when you loop through the result set put some condition like if $counter==1 then ... else.... -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --