fenway

As listed, KEY is just a plain old index -- no "constraint" of any type.

...Did you miss the scrollbars? No, I didn't -- that's not SQL, that's PHP.

Yes, INNER JOIN.

Also, at no point did you actually share the query with us.

FYI, you can't mix GROUP BY and those columns that way.

Simple question -- are you using a DB class, or are you coding each sql statement yourself? If it's the latter, you're likely vulnerable.

Or just a subquery.

Closure tables are a less painful option.

No, I don't provide "full code". There are countless examples on this forum of using user variables as counters.

I like nested sets -- but they're slightly annoying to maintain (parent, depth, ancestor, etc.).

Are there errors now?

But that's always the case, whether it's 1 table or 4 -- you can't know what's in the other table until you look.

...assuming the permissions are set up correctly -- LOCAL isn't allowed by default.

Why don't those additional tables have an article_uid?

Sure -- use SUBSTRING_INDEX().

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=343905.0

That link is precisely how to do it. Of course it's advanced -- you're asking an for advanced query. You had the option of just running it N times, but you didn't like that.

Yeah, you have to do weird stuff with NULLs -- easier to use use "WHERE confirm <> 'y' or confirm is NULL".

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=343851.0

You're asking to retrieve N records per group -- yes, that's possible, and efficiently, too. See here.

You don't need the column names per se -- just change it to: INSERT INTO `brand` VALUES (1,'No Brand','No Brand','no-brand.jpg',0,NULL),(2,'686','686','686.jpg',0,NULL), ...... And you're done.

Then you might as well number them in PHP -- or, if you insist, use user variables in mysql.

You're trying to assign rank in mysql? There are dozens of tutorials. You're just asking for a counter, right?

There aren't matching rows in the proposal_files table -- that what I asked originally -- so obviously the query won't work. You need to check your data more carefully before you ask for help with a query that you think is "broken".

Assuming you know the column names, and know that they're in right order, it's a multi-valued insert statement.