fenway

That's not the code that's generating that error.

Why do you think you need new columns?

That's not what I meant -- I meant you're not cleaning those input values to protect against SQL injection.

Without a DB wrapper, they're both wrong.

You need to read a PHP syntax manual.

If you're dynamically changing the number of columns, you're doing it wrong.

Show us EXPLAIN output.

You don't need to switch the column, unless you always mean that -- you can just collate in your query.

I'm guessing -- depends how you're populating and pulling from that DB.

You're new -- read the terms of service.

Sure -- but for anything other than a single, correctly-spelled word, you're S.O.L.

"Showing" has nothing to do with mysql -- you need the correct query to get the desired value first.

I have no idea how you know which one should be next.

That's what FULLTEXT is for.

I think you mean SUM(credits) -- and obviously, with some sort of link between the 2 tables.

I'm guessing the load is the curl part -- not sure what the db has to do with this.

Then your only choice is timestamp vs date -- choosing the latter is really only advantageous with timezones.

We're at 30+ replies and we're going around in cricles.

There are dozens of ways... I have no idea how you're connecting to your DB. Something as simple has a modulus based on the seconds of the day would work.

Echo the query and the error.

You need to JOIN those other tables first.

That's becuase your BETWEEN is wrong -- needs to go from low to hi.

Why do you need this, anyway?

One row per pair.

There is no such thing. Besides, aren't you the one changing them/