Vintage Electronics We Source All The Vintage Electronics You Need

Vacuum Tubes, Fuse Lamps and Tape Deck Reels and more…

Table Radio Tubed

without comments

Table Radio Tubed

Table Radio Tubed
Single MYSQL query to fetch all parents and child for a given node?

Hi,
We have a mysql table category whose structure is as follows
category_idname parent
1 ELECTRONICS null
2 TELEVISIONS 1
3 TUBE 2
4 LCD 2
5 PLASMA 2
6 PORTABLE 1
7 MP3 PLAYERS 6
8 FLASH 7
9 CD PLAYERS 6
10 2 WAY RADIOS 6

Is there a single query that would return us all unique parents and child for a given category id?
Please help

Thanks,
Vijay

i dunno

No items matching your keywords were found.


Motorola Custom 6 table radio 1957




Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • FriendFeed
  • LinkedIn
  • MySpace
  • Ping.fm
  • Posterous
  • StumbleUpon
  • Twitter

Posted in Vintage Radios