fenway

yeah... but how? See here.

FYI, it also depends on charset and if you ever sort on these columns, too.

I don't click on links... some sample output, maybe?

Don't hold your breath on Falcon... I'd check out Sphinx.

Because '0' is not a valid date/time... does that surprise you?

What's "not working" about it?

USING is not "equivalent" to ON... there are some subtle differences depending on version that may or may not matter.

Um... guess not... looked like more code to read, as opposed to a working query... my ba.

UNIONs.

Why not just JOIN them?

mysql has no concept of next/previous. not sure why you need the level, can't you tell directly? also, why not build this structure in script?

LIKE will work, albeit poorly.

"simultaneously" doesn't make any sense... what do you actually want?

Then PLEASE stop asking for code!!!!

It's not great... duplicate issues, typos, etc... why bother?

I don't understand.

This is not a mysql problem... confirm and I'll move it. You're talking about printing headers!

I gave you the only idea.

No errors? If you have php questions, post in the appropriate section.

This has nothing to do with mysql.

If you're LEFT JOINing, you need to make any where clause conditions pertaining to the left join'ed table to the on clause.

right.

Then post the final working solution, please.

Well, I suppose you could still "number" them somehow and then filter the "rank"....

Sorry, going cross-eyed today, that looks fine -- I still don't see why you can't directly compare NOW() to start, though.