small query problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Locked
User avatar
itsmani1
Forum Regular
Posts: 791
Joined: Mon Sep 29, 2003 2:26 am
Location: Islamabad Pakistan
Contact:

small query problem

Post by itsmani1 »

my query is :

select * from category where parentid =6

this gives me all children of number 6, I wanted to select name of cat 6 as well.

Please help me out
User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Re: small query problem

Post by Ambush Commander »

Do another query.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: small query problem

Post by pickle »

Locking topic as this is a duplicate.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Locked