fenway

Why the cryptic column names?

You shouldn't be modifying the users table yourself anyway -- there's a CREATE USER command now.

update t1 inner join t2 on ( t1.apn=t2.apn ) set t1.match = 1 where (....)

Well, you don't know how to "build tables" -- so someone should tell you before you break something. I really hope you're not being paid for this work, since you're about to screw over your client. What you consider 'solved' everyone else in the world considers "broken". And don't tell me how to help -- I can't tell you how to listen.

Maybe *in* the column list.

Then something in your php script isn't set correctly.

That means you're not properly entering UTF-8 characters.

That's great -- but next time, use code tags.

You simply need to strip both values when you compare them.

Sorry -- you mean you need to add the price for each day of a given period, once per day?

That requires one row per month, not one column per month. What if you even wanted to store 2 prices per month?

On a 32-bit system, 4GB -- otherwise, no. But that's billions of rows.

You have a column called "Jan"? Seriosuly?

select count( distinct column ) from databasename

Because that means I need to parse your entire script to help -- and from what I can gather, it's not specifically a mysql question.

Huh?

That's a php error from a DB class -- no idea.

Well, the entire script was a bad idea, too.

Just a second -- I'm confused why you want to do this in the DB?

Show me what sample output you're looking for.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=332949.0

Aggregating a SUM usually requires a derived table.

Posting the entire script, with login credentials -- probably a bad idea.

Right -- you need to iterate through the result set.

Yes, and it always has "drop tables".