fenway

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.

That means you're successfully logged in to the mysql client...

Oh, it's impossible -- don't even begin to try. You don't need this number.

And there's nothing wrong with a subselect to get the total count for everything - super easy.

then "locate" mysql and run it from there.