fenway

And fail if it doesn't match both?

No, it's ACTUALLY impossible -- it's not just hyperbole. Unless you're running this query with only a single user, no outside connections, no INSERT/UPDATE statements, no query cache, etc., you'll NEVER be able to know exactly how long a query will take. This isn't my opinion -- it's fact.

I agree with you -- but you're trying to UPDATE it in advance.

You need another table of cateorgies, and another of questions.

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

update yourTable AS t1 SET t1.newField = ( SELECT ID FROM yourTable WHERE name = t1.name )

Or add a "sortorder" column.

Great. Now, back to your question -- which code snippet are we talking about/

Well, then it should be pretty straightforward -- assuming each name has only a single ID, and vice versa. Add new columns called animal_id, theme_id, etc. to the appropriate tables -- these will ultimately replace the name lookups. Then simply issue an update to each table, and use a subquery to pull back the ID for each given name. Then you can drop the other columns -- once you've updated your application code, foreign keys, etc.

You can't use GROUP BY and those title fields together.

I'm guessing it's a delimeter issue.

Are those IDs unique?

I've locked your other two topics -- clearly, you're starting a new thread for each incremental change to the same script. Please keep the discussion in a SINGLE thread. Also, it's bad form to post an entire script.

You're now onto your 3rd thread.

That's because "l_word_id" is a SINGLE string literal value, not a list.

Don't double-post.

Neither -- it increments the month value by 1, nothing more.

Where's the query?

That doesn't make sense -- you got to the "mysql>" client prompt.

You need to re-think your table design first.

Why update the marks on-the-fly? Just calculate them at run-time.

Then don't write queries manually.

Is that output the desired output, or the sample input?

That still doesn't answer my question -- I know you're searching two names, but does it have to match BOTH?

You don't need an entire site, just a page to which you can't navigate with knowledge of the exact URL -- Google won't care.