fenway

CASE WHEN rank > 11 AND rank < 50 THEN glorypoints = glorypoints + 1 WHEN rank > 0 AND rank < 12 THEN glorypoints = glorypoints + 2 END CASE ...etc.

Ignoring the fact that this isn't a good idea in the first place, the issue is likely quoting. You need mysql_real_escape_string().

This best handed with CASE.

There's no "log of a negative number is imaginary" forum.

If you set your variable with ( SELECT @yourVar := 'yourValue' ) in a derived table, it's easier.

Yet another table, with competition_id and book_id.

That's a math issue, not a mysql issue.

Well, i'm just wondering how you're query for such dat.

Ah, yes -- with JOINs -- are you familiar with these?

I mean that if you query for "truth", instead of storing "state", there will be no book_selected field to update.

It's always bothered me that you can't use a derived temporary table.

HuH/

I don't follow.

Post the actual, raw query, not php code.

Don't store flags in the db.

Next time, how about posting your solution ?

None of this matters. You need to store a clean version of your strings, depending on how you're searching. Substring matches depend on the content, same with the definition of "alphanumeric', the list goes on. Without true full-text searching (i.e. stemming, etc.), this is all smoke and mirrors.

Cron jobs are much, much, much more reliable than replication.

Yeah, but that's evil data storage.

You're new -- next time, use code tags.

Did you explicit grant the drop privilege?

There are countless blog posts on this kind of thing.

Something similar... but you can make that variable in the WHERE clause, and thus it's a single statement.

You just need to join twice, and count the number of posts.

I mean inline, in the same query.