Simple.. SELECT (RETURN) N_Numbers_Of_Categories_Id From Categories_Table

Databases
1

SELECT (RETURN) N_Numbers_Of_Categories_Id From Categories_Table

How to ?

My Table : categories
Columns are
Id , int
name, varchar(255)
parent_id , int

Data is stored as
ID Name PARENT_ID
1 A 0
2 B 1
3 C 2
4 D 3
5 E 4

I want out put like

Column name ID
Values will be
1
2
3
4
5

HOW TO… Need Simple SQL Statement HERE!

2 
SELECT id
  FROM categories
ORDER
    BY id

:slight_smile:

3

I am searching query like



Well [B]r937[/B] WHERE IS WHERE CLAUSE IN YOUR SQL QUERY FOR JOIN
4

don’t get angry, but the solution i gave you works perfectly for the requirements that you gave in post #1

now it appears that you want something different, but you have not explained it very well

5

JOINs are not used within WHERE. You also shouldn’t get angry with people who are helping you for free and you really should learn the basics of SQL before trying to argue who’s right and who’s wrong :slight_smile:

6

So show can you collect with n number of Categories with this SQL Statement

SELECT c.name , c.id, (SELECT COUNT(p.id) as total FROM posting as p WHERE p.cat_id = c.id AND p.mode = 1) as total1 FROM categories as c WHERE c.cat_type = ‘1’ AND c.mode = 1 AND c.cat_parent = 0 ORDER BY name

???

7

I have tow tables

Each POSTING have Any SUB OF SUB OF SUB OF SUB OF CHILD CATEGORY MEANS 5 LAVEL OF CHILD CATEGORY WILL ASSIGN TO ANY POST BY FOLLOWING JOIN

posting as p , categories as c WHERE p.cat_id = c.id

MY TABLES

CREATE TABLE IF NOT EXISTS categories (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
descc text,
cat_type int(11) DEFAULT ‘0’,
cat_parent int(11) DEFAULT ‘0’,
seo_keywords varchar(255) DEFAULT NULL,
seo_desc varchar(255) DEFAULT NULL,
title varchar(255) DEFAULT NULL,
marque text,
image varchar(255) DEFAULT NULL,
seqno int(11) NOT NULL,
mode int(11) DEFAULT ‘0’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;

–
– Table structure for table posting

CREATE TABLE IF NOT EXISTS posting (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
user_id int(2) unsigned NOT NULL,
cat_type int(11) NOT NULL,
city_id int(2) unsigned NOT NULL,
country_id int(11) unsigned NOT NULL,
location varchar(255) NOT NULL,
type int(2) NOT NULL,
cat_id int(11) NOT NULL,
title varchar(255) NOT NULL,
amount int(11) NOT NULL,
phone_number int(11) NOT NULL,
desc1 text NOT NULL,
listner_type int(2) NOT NULL,
featured int(2) unsigned NOT NULL,
publish int(2) NOT NULL,
map varchar(255) NOT NULL,
publish_date date NOT NULL,
mode int(2) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

I WANT OUT PUT LIKE

SHOP (10) "Title (Total of 5 lavel of child )

i did following MySQL query

SELECT c.name , c.id, (SELECT COUNT(p.id) as total FROM posting as p WHERE p.cat_id = c.id AND p.mode = 1) as total1 FROM categories as c WHERE c.cat_type = ‘1’ AND c.mode = 1 AND c.cat_parent = 0 ORDER BY name

But it collect 2 laved of child category while simple We want N lavel of Child Category TOtal…
HELP … PLEASE!