[SOLVED] Setting a field equal to a count in mysql

[tibberous]

I have two tables, games and categories. Each game have a category field, which holds the id of the category it belongs to. Each category keeps track of how many games are in it, and records it in the gamecount field.

 

Is there a way to set categorie's gamecount field to the number of games with a certain category, all in a single query?

 

select count(*) from games where category=1

 

returns a 4.

 

And...

 

update categories set gamecount='4' where id='1'

 

But

 

update categories set gamecount='(select count(*) from games where category=1)' where id='1'

 

Doesn't do anything. Anyone know why?

[Jessica]

Did you try removing the ' ' around your sql query? It looks to me like you're just setting it to that string, instead of the result of that query.

[tibberous]

!!!

 

Damn it! Thats it...

 

I thought I was missing something fundamental with subqueries, here it was just something stupid.

 

Thanks a ton.

[Jessica]

No probs