fenway

Your if() is retrieving rows, then the do/while is retriving rows... don't do that. A simple while loop will suffice.

What is your table structure?

Don't the transactions have a date?

LAST? What is that supposed to do?

GROUP_CONCAT()?

Yes... STR_TO_DATE.

That's called replication.

You can use AVG() like COUNT()... but still, having a month column isn't ideal.

That is the sample code... and it's TABLES. I suggest you take a closer look at the refmac.

SHOW TABLES will get you the listing... the other question you have is a php issue.

Related? You mean you need the LAST_INSERT_ID?

I've always used "ORDER BY FIELD( myField, ...options-in-reverse-order... ) DESC, myField", because it's more robust -- alphabetical isn't always desirable. The IN clause just a boolean.

You can use DATE_FORMAT() to get any piece you desire -- don't ever split up the date into pieces.

First, why all the parens? Second, that's impossible to read... and third, what's the question?

You're storing just the year?

You're talking about vertical partitioning... that's an advanced technique.

That's because that's not valid syntax... try INSERT INTO a (a) VALUES('aaa');

mysql has some backup scripts.

Ugh... mysql has a period function, you should store your dates properly.

I'll make my usual suggestion of building an array.

LOAD DATA INFILE?

Not really...

Try xaprb's MySQL Toolkit (a.k.a. Maatkit).

I have no idea what this means.

FULLTEXT indexing supports this type of thing.