fenway

I don't follow your second example.

Well, which "one" of the many matching rows would you want... how would you decide?

You need to specify a table prefix, just like for your ON condition -- use t2.ID.

It doesn't ... unless you (or your IDE) used backticks.

Yup... mysql date math is very powerful.

Show the desired order... also, are these the only examples of possible content?

Huh?

Everything -- script, db connection, etc. -- need to be UTF-8 aware.

Check the section_id that you're passing in, and all of the section_ids from your query.

Do any users have the replication privilege?

Welll, you're doing an inner join, so you'd need all 3 selections made for the code to return anything.

Even faster if you use COUNT(*).

Just be careful -- there's a maximum length to group-concat which is very short by default.

everything is possible...but only with table structures.

Why not... simply compare a list of recipes with total # of ingredients to the number of ingredients available.

Nowhere near enough info... but there are countless tutorials on inserting images into mysql.

Those are separate issues -- kickstart is trying to figure out which side is the problem. I was simply trying to determine if the data is coming back properly, irrespective of htmlspecialchars(), with has nothing to do with mysql.

Hmm... I would have thought you'd use those in the column list? Not that it really matters in this case.

It's important to determine if the query itself produces the correct resultset, and the php logic is flawed, or vice versa.

Agreed... but if there's a fixed format, you can fudge it.

Interesting approach... wonder if the UNION logic would have been simpler, though.

Yes, I agree that it's fine... so where's the mysql issue?

Hmmm... those seem reasonable. Have you confirmed that you have a valid connection to each DB?

Yes... avoid correlated subqueries if possible; but not all of them are evil.

Assuming you have a backup, there are many other options to REPAIR that you can issue.