NameSilo

[Resolved] Small MySql help needed

Namecheap AuctionsNamecheap Auctions
SpaceshipSpaceship
Namecheap AuctionsNamecheap Auctions
Watch

TEGnet

Established Member
Impact
0
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
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
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
 
1
Close
Thanks peter but i got it solved already.
 
0
Close
DomainEasy: white label portfolios are live. Enable yours.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Search: choose where to search from the All tab
Open the search at the top of any page. On the All tab, the list next to the search box lets you choose where to search: everything, all...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back