fenway

UTF-8 covers most characters, unlike latin1, which you are using.

Long time no see.... I usually use a "one-time passcode", like a random hex-string of 40 characters (say, an MD5 hash of something), and e-mail it to them, and have it expire after 24 hours or when it's been used once.

Huh?

Sounds like you need a UNION. BTW, BIGINT is likely waaay too big... just slows down index usage. INT UNSIGNED is more than sufficient, since I doubt you'll have >4 billion records in a single table.

It all depends on the cardinality of the indexes.

You can't execute multiple statements that way.

Nope... DISTINCT isn't even a function itself. You can filter those in PHP code.

Yikes... why not use a proper DATE field?

Not from a single-threaded script, no... but that's well outside the scope of the mysql board.

It's not "solved" until you post the solution.

Not sure... but that's outside the scope of this forum.

Yup... DAY() was added in v4.1.1 -- use DAYOFMONTH() instead, it's the same function.

That was instead of the loop.

I prefer CONCAT_WS( '', Firstname, Lastname) -- makes it easier to add more columns.

the "site" is not the "database", so no.

Which version of 4?

I'll second that... it's always good to know that the community is having a positive impact!

Don't mess up db normalization with the hopes of a high-load environment. solve your current problem now.

COUNT(*) = 1 plus 1 = 2. Where's the confusion?

Yeah, I do it often for bulk inserts.

They can be... especially when you're using fields from the left-joined tables. If you need left join, you have no choice.

We don't need all the code... just the db statements. You're running an update statement without a where clause!

I have no idea what you want.

There is no "after" -- join them to begin with. SELECT a.*, ua.* FROM user_ach AS ua inner join ach AS a ON ( a.id = ua.ach_id ) LEFT JOIN cat_order AS co on ( a.name = co.cat_name ) WHERE ua.user_id = $cookie AND ua.ach_id = $counter ORDER BY co.cat_num

Try doing (2) and (3) independently.