fenway

You're not closing your column list with a parent.

Well, I don't see any reference to month/year in your join condition.

Just suggesting that BETWEEN is a simpler operator to use.

The error was simply the fact that the outer table alias isn't visible to the subqueries.

With DATE_FORMAT().

"Topic solved" button right above the quick reply area.

That's *precisely* what enum does. But aschk is correct -- ENUM is usually a futile shortcut for non-system fields.

Then please post your solution for everyone's benefit.

Leave your WHERE clause as-is, and add an expression to your column list -- like CURDATE() BETWEEN start AND end

Like with yet another JOIN?

What does "slip out" mean?

You can try using multi-valued INSERT statements... but yes, php has a max execution time.

Use table aliases and prefixes.

Both PHP and MySQL offer md5 functions.

You could use IF() to check for the Y condition in the order by clause.

Huh? You're only getting back one field.

No, square brackets are not ok.

That's something called a "cross-tab".

So you're trying to join those tables base on name and month/year?

Not sure this is really a mysql issue...

This looks like a double-post...

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets (PDF).