[Resolved] Small MySql help needed

[TEGnet]

Small MySql help needed

K i have these tables here

1. Category
2. Content

the category table has these feilds
a. id
b. title

the content table has these feilds
a. details
b. category < so that it will go under certain category id

now what i need help is how do i count the number of details that a certain category has using mysql

 

[Peter]

you will need to tell us a bit more on how the tables relate.

But loosely you could do something like:-

select count(field_name) from table1 AS x, table2 as y where y.field_name = x.field_name

 

[TEGnet]

Thanks peter but i got it solved already.