fenway

Great-- then share and mark it "solved".

Sure.

Why is that a problem?

Nowhere near enough info... read the main sticky on this board. At the very least, we'll need some example queries that are causing issues and their table structures, etc.

Define "clean".

No, you don't understand the logic.... do you want to find all instances where there are *all* of those related records?

A whole lot of things need to be set to UTF-8 correctly... php, mysql, and whatever editor you're using.

Don't mark topics solved unless the solution appears in the thread.

You can group by week and year.

So you don't get an error from mysql_query? How are you iterating through the rows? With mysql_fetch_assoc() and a while loop, I hope....

You can mark it as solved... bottom -left above quick-reply; and tell us how your solved it.

Enough with the code... that's not going to help. Post your table definitions.

You have order-of-operations issues... precedence and paren placement matters. And why not use !=?

Then use a GROUP BY -- DISTINCT is useless.

Wait... whyare you creating a new table to do this?

Do it the other way... group by on your images table first, then join it back.

I believe there's a UDF that can do this... but you can always siimply insert a record into some table, and then a have a crob job / script deal with it.

No issues with this... it's actually helpful sometimes (though rarely). I simply meant for index usage -- and I think I never saw the explain for the LEFT JOINed version.

It wasn't an article, it was a refman page. Are you talking about storing the related records, or retrieveing them?

Not sure what the relationship between project_name and project_phase_img is... but it might be garbage output.

4NF? That's likely going too far.... FKs don't auto-retrieve, they just serve as constraints.

That's not valid... you mean INSERT INTO `day` (`id`, `class`) VALUE (SELECT `id`, 'S' FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`)

There's a refman page on sockets that might be helpful here.

Well, maybe "many moons ago" it didn't matter, but it does now -- echo the query and post the results here.

Those are some heavy queries... serious optimization would likely be needed here.