fenway

You have to assign it back to the quote variable...

Yes, it's a quoting issue... escape your nested double quotes.

TRUNCATE TABLE if you really want to delete everything; otherwise, don't.

Echo the string you're passing to dbquery().

Anyway, order by makes a temporary table, which is likely your issue... depending on your memory situation, you might be able to increase the temporary table size.

You should standardize it right now...

See this refman page.

Is there DB? if not, you need to start way before the code.

You need to check the value of the "friday" field... ugh... but this is not a mysql issue.

A LEFT JOIN on the union'ed table could work.

You shouldn't ever have low disk space! On a DB server?

5.1 does have an event schedule.

LAST_INSERT_ID().

you can't use = with null.

Yes, that fine... otherwise you'd need `link_status` NOT IN ( 'discarded' )

setTimeout?

I assume you mean team names? select p.name, t.name from project_teams as pt inner join teams at t on ( t.teamID = pt.teamID ) inner join projects as p on ( p.projectID = pt.projectID ) where pt.projectID = 5

The problem is that you can't group by in the "middle" of a join... or LIMIT a join. One way to do this would be to use user variable to assign a value of 1 to the first 5 from each year, and then a 0 for the remaining ones -- and then filter with HAVING magicField = 1.

What does that query produce?

String out the commas with a regex, then eval.

The mods are fairly confident that this is now under control.

you have a list in a single field -- that's a no-no. HAVING is not the right approach. You can probably get away with "WHERE FIND_IN_SET( authors, '$user_id' ) " simply because it's a comma. But this is poor DB design.

No, it's not. And you're missing a close paren, so it's definitely isn't. Whatever tool you're using should produce a proper query... post it here.

You can also mark the record as being edited... but that's annoying for the user. You have to decide what's more important... the user or the dta.

Replace '$today' with NOW() or CURDATE() as applicable.