fenway

If you properly quote all of your strings from user input, you won't need to "test" it.

You can use: WHERE EXTRACT( YEAR_MONTH FROM_UNIXTIME( yourTSColumn) ) = '200812'

NO NO NO NO NO! This will not work at all -- you cannot rely on any value retrieved from a group by other than aggregate functions or the grouped column(s). Please post your table structure.

This is obviously not related to the mysql query... please confirm if this solved the issue, or I'll move it to the appropriate forum.

what do you mean "might not exist".... the tables or the matching values?

no way to figure out what the "original" one was... but how could that be relevant?

Check mysql_error() to find out exactly what's wrong.

Then at least post a link back to the old thread for continuity... besides, what was the final solution?

Not sure how you mean... you mean dump a list?

I was actually looking for the representative code/query...

Then please post is here, otherwise this entire thread is just very confusing.

Double-post.. you've been warned.

Where's the include? And this is straying very far from mysql

NO! Never post ALL of the code... we never need to see it all.

Next time, please refrain from posting the ENTIRE code when 5 lines will suffice. And PLEASE echo the query.

Yes/no fields are not going to use an index anyway.

You didn't close the single quote for the email field.

That shouldn't be an issue... simply the query, make sure it works with a single one.

Huh?

As I suggested in your duplicate thread, derived tables.

Sphinx?

TLDR.. but you should be able to use derived tables. TOPIC LOCKED... duplicate thread. Don't do that again, please.

Yikes... you just gave 35 ppl all your login credentials... I suggest you switch them ASAP!!!!! But regardless... this isn't anything of the ordinary unless it happens repeatedly.

What does that 2nd query accomplish? And you have two ON clauses back-to-back.

Check the stickies.