fenway

That's a lot of code. If there's no default, and you don't specify a field, and you're using mysql 5 in strict mode, it complains. Either give it a default or specify it explicitly.

The obvious question... you're storing time in a varchar, and you have a timestamp without a time!?!? The only way to do this now, without fixing it, is to use STR_TO_TIME() to fix the time to proper TIME field, and then order by it.

User authentication?

You can't ping localhost?

Hey all... I have a semi-potential client that seems keen on exploring smartsimple.org as an alternative to getting their web-site rebuilt from scratch (e.g. custom programming). I obviously think the former is a bad idea, much like all turn-key solutions. I know nothing about this service... does anyone else?

You can't switch to mysqli without enabling the extensions first.

I never said it didn't work. But your quoting is all funny, so pls show us the actual sql query issued to the server.

That seems impossible... echo this string.

It's not in the browser, it's in your code. There's a sticky in the child forum too.

"500 each" what? Load shouldn't be a problem.

DELETE t1 FROM mytable AS t1 INNER JOIN mytable AS t2 ON t1.userid=t2.judgeid

You need parens with OR.

Well, you can COUNT() and GROUP BY word... the count is the numbers of "dupes" in your case.

Yes, it's just the column mapping. Are you sure you have CRLF and not just LF?

mysql_connect_errno() or mysql_connect_error()?

Sadly, not really.

Sure, use a SUM() and group by date... assuming, of course, that you've stored dates properly.

You'd need to delete using a self join.

AFAIK, you can't run multiple statements at once.

Sorry, I glanced over the period function... interesting approach.

You can tack on a "LIMIT 0" to just about any SELECT statement.

You need a range... an equality won't work..?

You realize that help is NEVER stored on disk, right?

Because the first line isn't data.

If only code blocks would respect php highlighting too... or, equivalently, if php blocks were scrollable.