fenway

Oh, definitely not... but I think everyone can breathe a sigh of relief, at least for a little while.

You need to store those as DATETIME. But mysql will let you get away with that for now. Simply use "WHERE LogDate < NOW() - INTERVAL 1 DAY".

Then don't use the plus sign.

SOPA is dead -- long live the Internet ;-) http://yro.slashdot.org/story/12/01/16/1457237/house-kills-sopa

Don't start a new thread for the same issue. kickstart gave you the answer -- and a better way to do this anyway.

That's still php code. A statement is a raw string -- you'll need to show us those.

You can usually start services manually via the "services" control panel interface -- but if you installed it correctly, it should run at startup. I'm fairly sure it's trivial to change.

That's layout -- use a hash.

That depends on the optimizer for your version of mysql.

In fact, never use DISTINCT.

Post the raw SQL.

Technically, there's a way, but it's buggy, so don't. If you don't want it repeat, do the math afterwards, not in the SQL statement.

I don't see SQL statements -- I see php code.

Now that we're debugging php output, perhaps this isn't the best board any longer?

You don't need post numbers.

You have to have (a) the same number of columns and (b) they have to be of the same type.

We're going to have to start again... I can't follow this any more.

Also, it won't work at all, since you're single-quoting your column name.

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

First, that's a PHP error. Second, you have quoting problems. Third, you wouldn't have this problem if you used a proper function to create your SQL statements.

And you can't guess what column your own DOB is stored in? Does kickstart have to do everything?

This just screams "FULLTEXT INDEX".

Yes, but that's a different level of compliance.

Why do you think you want this?

Post the SQL query itself, and the error.