Skipping a row, whilst sorting a table

[londrum]

i'm guessing that this is probably impossible, but im hoping someone brainy knows how to do it...

i've got a page which displays a table of data, which is sorted by date. so far, so easy.

but when it comes to two rows in particular, i need them to appear as if they were the next row down. so when the script prints all the rows out, i need to skip over them for just one row, and print them after the next one.

is that possible?

[rocknbil]

Me gotz nuttin' . . . in mySQL anyway.

What are the "identifying factors" of these rows? Are they a series of conditions you can pick up via programmimg without hard coding them?

[LifeinAsia]

Can you provide some example data? Will it always be those 2 rows, or rows meeting certain conditions?

[londrum]

i think i've resigned myself to adding a new column.
but this is what the problem is...

it's a database of songs. and i can sort them alphabetically and by release date, because they're the only columns i've got.

when i sort them by release date, and two songs share the same date (because they are the A and B-side of a single) i naturally want to list the A-side first. but at the moment i can only list them alphabtically, which is wrong about 50% of the time.

so i was hoping i could get it to skip a row every time a certain song title came up.

[LifeinAsia]

Yes, I would add another field and do a secondary ORDER on that field.

[enigma1]

or you could expand the date col to be datetime and then set the secs for instance to force ordering without an additional col.