fenway

This sounds exactly the same as your other thread -- please clarify

At the end of the day, it's still a set of credentials.

Also, PHP will do this much better.

So what are you asking for?

You're not too far off -- but you want that CASE expression in your select column list, not your WHERE clause. And the LEFT JOIN with IS NOT NULL is really just an INNER JOIN.

SQL Antipatterns (Bill Karwin) is fantastic if you're just starting out. High-Performance MySQL (Schwartz/Zaitsev), 2nd Ed., is more advanced, but it's still a relatively easy read for at least 2/3 of the book

Did you try?

Without a log of sql statements, it's hard to say -- are you using connection pooling?

Your username & host for the grant must be quoted as string literals.

There's always a way -- just figure out how many different formats you have, and update accordingly.

In fact, the refman says so.

You know, there's a sticky that describes exactly what information we'll need to help you.

You query the DB in whatever way is more efficient -- then it's to you to create you own objects to house the data -- not MySQL.

Not true at all. VARCHAR can be up to 65,535 in version 5 -- and it's much better to use this than TEXT -- which, by the way, has no "size".

That's because the MAX() already uses the aggregated results -- I'm not sure what you're trying to do here.

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

The "solution" is to store it different -- I already to you that. Otherwise, you'll have to explode() everything in php.

Slow as hell... use COUNT(*).

Yeah, we can't guess what you're telling the server to do.

Then post it for everyone to see.

Sounds like a simple join on ZIP.

Well, you're not using the data from the database.

Show us the join you had.

Yes -- you're getting back all of the data just to count.

You need a JOIN, is all.