fenway

No, you have to join it AFTER that query, since you're using GROUP BY -- take that entire query, make it a derived table, and join it again. Wait a second, maybe I didn't understand your original question?

I mean that one bmonth value from one table matches more than one record in the other table.

Or use back-ticks... but better to change the name.

Then you need to join again.

First, you can't select * with a GROUP BY. Second, I don't even understand the question.

the parent_category_id can point to another subcategory.

Then it sounds like bmonth isn't unique enough.

Would you mind posting your solution for everyone else to see? And always GROUP BY, never DISTINCT.

I thought you had to specify VARCHAR sizes.

You normalize your database.

I meant check both, not database AND. Sorry about the confusion.

Sorry, not much sense.

It most definitely can.

No idea about the php stuff.

As is DATE, but apparently, it's context-sensitive reserved.

Echo $query.

Can't you simplify this to check to the following 1) OE < NS AND OR 2) OS > NE Assuming you can rely of end > start...

The "20%" and "up to two" should have given it away....

What queries have you tried?

What do you have so far?

Two things --- first, DISTINCT is not a function, it's a modifier to SELECT; it filters out rows where ALL field values in the column list match. Very different than GROUP BY. Second, you can use FIND_IN_SET() if you values are comma separated without all that string manipulation. But it's a bad idea to store lists in fields.

Um, you need a WHERE clause... use the $id!!!!

The mysql site has plenty of dev articles on this subject. As for remote IPs, yes, you have to make sure you can connect non-localhost on the given port.

Take a look at this resource.

Like I said, determine them in an earlier query, and there's no difference.