fenway

It can't be equal to two things at once; you need to use OR, and the check the count in a having clause.

Like AJAX?

What does an "image" row look like?

Well, SELECT * FROM PtInfo WHERE Last_Name LIKE 'Fr%' will work....

Yes, there were some incomptabile changes w.r.t timestamp....

I'm not sure what you mean... you mean you want all matching pairs of (skillID, gradeValue)? That's not "all" criteria... unless you want only the ones where at least one row matches each one? Please clarify.

Give some examples.

Then that code isn't working or you're not calling it.

First, use double-quotes for the outer string, and singles for the mysql literals. Second, echo the $sql variable.

You can COUNT() the number of rows returned for each.

OFFSET for LIMIT?

Both, but time is more important -- unless the table really grows, and then index performance drops with increasing size.

LEFT JOIN byrnjobdb.surveys ON byrnjobdb.jobs.survey_id_2=byrnjobdb.surveys.survey_idOR byrnjobdb.jobs.survey_id_3=byrnjobdb.surveys.survey_id

Um, no.... read this.

You can use OR in an ON clause.

Did you change versions? There's no way that any DATETIME field will show the value you indicate.

Maybe because you're missing the column type?!?!?

Actually, that doesn't entirely work as advertised if there are non-matching items to be ordered...

There is, but it's not pretty... there are all sorts of ways to cheat; the laziest is simply to throw out anything after the 4th.

What's wrong with that query?

You shouldn't use a minus sign in your column name -- underscores are much better!

UNSIGNED will prevent it from being stored... but you'd have to catch the error when trying to set it (strct) or the warning (not strict).

Yes, and that "button" triggers a form action that will get processed by PHP.

Well, not multiple "ORDER BY"s, just separate groupings, is what I meant to say. For example, ORDER BY IF( t.topic_type = 1, 0, 1 ) ASC will always put topic_type 1 first. Then it gets more complicated...

Use STR_TO_DATE().