Small MySql help needed

TEGnet · 02-22-2008, 03:37 AM

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 · 02-22-2008, 11:00 AM

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 · 02-22-2008, 11:24 AM

Thanks peter but i got it solved already.

02-22-2008, 03:37 AM	THREAD STARTER #1 (permalink)
TEGnet NamePros Member Join Date: Oct 2007 Posts: 114	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

02-22-2008, 11:00 AM	#2 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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 __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

02-22-2008, 11:24 AM	THREAD STARTER #3 (permalink)
TEGnet NamePros Member Join Date: Oct 2007 Posts: 114	Thanks peter but i got it solved already.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)