fenway

Well, a NULL into a non-null decimal field would return 0.00.

And why the UNION -- are you actually running this once per UID?

Then I don't understand what you're trying to do.

And what is that code trying to calculate?

Emphasis added. Personally, I see absolutely nothing wrong with leaving orphans rows lying around -- makes fixing accidental user errors so much easier. Through, granted, with InnoDB, you can get screwed with UID re-use -- I always hated that.

I simply meant to say that any record deleted by "ON DELETE CASCADE" won't trigger any DELETE triggers on the cascaded tables.

I don't understand what you're trying to query.

If you're getting PHP syntax errors, you're in the wrong forum.

Also, cascaded actions won't trigger other triggers, so it's only a cascade in the most basic sense.

Don't you mean INNER JOIN? You want matching ones only, right?

Dependent subqueries -- avoid. Derived tables are subject to the same performance if they're derived or not.

I suppose you could use a derived table to get the photo counts for each such user.

The truth is, you can just count the rows that you get back -- there's no LIMIT clause -- so why the second query at all?

If EntryDate were a TIMESTAMP, MySQL would handle the timezones for you.

I've covered this before -- the GROUP BY / HAVING solution is incredibly slow on large tables. Just CROSS JOIN, once for each condition.

Trigger cascading is fraught will difficulties

First, don't bump. Second, you can't just tack on a count(*) like that -- it's meaningless. You'll need another query -- don't be lazy.

That's just lots of PHP. Post the actual query and the actual error.

If that's what you want, just sort the string yourself before you insert into

In general, you can always try "deleting" a user by just adding a "2" to the username -- that way, you don't have to re-create anything when you're wrong.

That doesn't make any sense -- try again.

That's not a query, that's php.

Or just paginate.

Using NULLs with date ranges is annoying, but you can store all zeroes.

Then you need to store the product order in the session.