Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

[Resolved] Small MySql help needed

SpaceshipSpaceship
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: flexible LTO options. Close more domain deals with financing.

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

Filters for activity feeds
Your news feed, Latest activity, and the activity tab on profiles now have filter buttons: All, Posts, Quick replies, and Other. Your...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back