fenway

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...

That's a php error, not a mysql error.

Solved how? This is a precedence issue.

Doesn't matter at all... you can still put the pieces back together so that you use a date field properly.

It only takes one parameter....

I don't even understand the question.

Echo the query.

I don't follow.

Looks fine to me

What's not working... show output.

You mean UNIQUE.

That's your browser displaying those characters, not the database. You can pad numbers in PHP -- don't make the DB do the work. And you can translate 0 and 1 easily in PHP.

That's because you're using the same alias twice.

Too little information...

And what's wrong with that?

You need to make sure "skip-networking" isn't on... and that you're listening & connnecting on the right port, etc.

Are you sure the grants have been set up correctly?

well, you could group-concat the events....

Echo the query itself.

I'm not sure I follow... and most comparisons are case-insensitive unless you picked a different collation.

Are you just counting? A simple join would suffice.