Jump to content

Ghost Categories


northwalesinks
 Share

Recommended Posts

With respect to cat_id 47, what is its cat_parent_id?   = 46

With respect to cat_id 99 Software what is its cat_parent_id?   = 0

With respect to cat_id 170  Eset what is its cat_parent_id?   = 46 

With respect to cat_id 171  Antivirus what is its cat_parent_id?   = 31

With respect to cat_id 172  Antivirus what is its cat_parent_id?   = 99

With respect to cat_id 175 Smart Security what is its cat_parent_id?   = 99

Link to comment
Share on other sites

cat_id

cat_name

cat_desc

cat_parent_id

1

Cases-Storage

Storage cases

0

2

CD Media

<p>&nbsp;CDR, CD-R,&nbsp; blank media, blank discs...

0

3

DVD Media

DVDR, DVD-R, CDR, CD-R, blank media, blank discs, ...

0

4

Hardware

 

0

5

Ink Cartridges

 

0

6

Paper and Labels

 

0

7

Printers

Printers and labeling Printers

97

8

Software

 

31

9

CD/DVD Cases

CD/DVD Cases, CD Cases, DVD Cases,

1

10

Storage Cases

 

10

11

DVD Duel Layer

 

3

12

DVD+R

 

3

13

8cm DVDR/RW/RAM

 

3

14

DVD-R

 

3

16

Paper

 

6

17

Labels

 

6

20

Cables

 

22

21

DVD Writers

 

4

22

PC Accessories

PC Accessories

0

24

Compatible Ink For Epson

 

5

25

FAXES

 

5

26

REFILL KITS

 

5

27

Toners

 

5

30

 

 

7

31

 

 

8

37

DVD-RW ReWritable

 

3

38

DVD+RW ReWritable

 

3

39

Matte

 

16

40

Silk

 

16

41

Gloss

 

16

42

Special Offers

<p>

   <a href="http://www.northwalesinks.com/store...

0

43

Lexmark

 

5

46

Anti-Virus

 

8

47

AVG Anti-Virus

 

46

48

NOD32 Anti-Virus

 

46

51

Routers

 

4

52

Mouses

 

22

53

Cleaning Cartridges

 

5

54

Cleaning Cartridges For Epson

 

5

55

Cleaning Cartridges For Canon

 

5

60

Sleeves

 

1

69

Mp3 Players

 

119

70

PressIt Kits & Labels

 

6

71

Dell Remanufactured

 

5

72

Samsung

 

5

75

Mp4 Media Player

 

119

76

Pen Drives

&nbsp;USB Pens Drives

0

79

CD Cases

 

9

80

DVD Cases

DVD Cases

9

82

Speaker

 

22

89

Headphones

 

22

90

Continuous Ink System

 

5

93

keyboards

 

22

94

Laptop Cases

 

22

95

Brother Printer

 

30

96

Epson Printer

 

30

97

Fax Machines

 

30

99

Software

<p>Software</p>

0

100

Compatible Ink for Brother

 

5

103

Original Canon

 

5

104

Compatible Ink for Canon

 

5

105

Webcam

WEBCAM

22

106

Labels

 

6

107

HP Remanufactured

 

5

108

Storage Cases

Storage Cases 240, 300, 630, 1000

1

109

Memory Cards

CF, M2, MMC, PRO DUO, SD, SDC, SDM, USB, XD digita...

0

110

SD CARD

 

109

111

MMC

 

109

112

COMPACT FLASH

 

109

113

MEMORY STICK PRO DUO

 

109

114

MICROSD

 

109

115

XD

 

109

116

RSMMC

 

109

117

MINI SD

 

109

118

Card Readers

 

109

119

MP3 / MP4 Players

MP3 / MP4 Players

0

120

Brother Printers

Brother Printers

0

121

Epson Printers

Epson Printers

0

122

Labelling Systems

 

0

123

Digital Photo Frames

 

0

124

Pitney Bowes Ink Cartridges

 

5

125

Toners

 

0

126

BROTHER TONER

 

125

127

BLACK TONER

<p>BROTHER BLACK TONER CARTRIDGE</p>

126

128

COLOUR TONER

<p>COLOUR TONER CARTRIDGE</p>

126

129

DRUM UNITS

<p>BROTHER DRUM UNITS</p>

126

131

CANON TONER

<p>High Quality Canon Toner Cartridges</p>

125

132

DELL TONER

<p>DELL TONER Cartridges</p>

125

133

Dell Toner Cartridges for Colour Printers

<p>Dell Toner Cartridges for Colour Printers&nbsp;...

132

134

Dell Black Toner Cartridges

<p>High Quality Dell Black Toner Cartridges for Mo...

132

135

APPLE TONER

<p>Apple Laserwriter Toner Cartridges</p>

125

136

EPSON TONER

<p>EPSON TONER CARTRIDGE</p>

125

137

Epson Aculaser

<p>Epson Aculaser Toner Cartridges</p>

136

138

Epson EPL

<p>High Quality Epson EPL Series Toner Cartridges<...

136

139

GESTETNER TONER

 

125

140

HEWLETT PACKARD TONER

<p>HEWLETT PACKARD TONER CARTRIDGE</p>

125

141

Hewlett Packard Colour Printers

<p>Toner Cartridges for HP Colour Printer Models</...

140

142

Hewlett Packard Toner Cartridge for Mono Printers

<p>Hewlett Packard Toner Cartridge&nbsp;for Mono P...

140

143

INFOTEC TONER

<p>INFOTEC TONER CARTRIDGE</p>

125

144

IBM TONER

<p>IBM TONER CARTRIDGE</p>

125

cat_id

cat_name

cat_desc

cat_parent_id

145

KONICA COPIER TONER

<p>KONICA COPIER TONER CARTRIDGE</p>

125

146

KYOCERA TONER

<p><span style="font-family: Times New Roman">KYOC...

125

147

FS Series

<p>High Quality Kyocera FS Series Laser Toner cart...

146

148

KM Series

<p>High Quality Kyocera KM Series Laser Toner cart...

146

149

FSC Series

<p>High Quality Kyocera FSC Series Laser Toner car...

146

150

LEXMARK TONER

<p>LEXMARK TONER CARTRIDGE</p>

125

151

MINOLTA QMS TONER

<p>MINOLTA QMS TONER CARTRIDGE</p>

125

152

Minolta QMS Toner Cartridges for Mono Printers

<p>High Quality Minolta QMS Toner Cartridges for M...

151

153

Minolta QMS Toner Cartridges for Colour Printers

<p>High Quality Minolta QMS Toner Cartridges for C...

151

154

OKI TONER

<p>OKI TONER CARTRIDGE</p>

125

155

Oki Toner for Black Printer

<p>Oki Toner Cartridges for Oki Black Printers and...

154

156

OKI TONER CARTRIDGE FOR COLOUR PRINTERS

<p>OKI TONERCARTRIDGE &nbsp;FOR COLOUR PRINTERS</p...

154

157

OKI DRUM UNITS

 

154

158

PANASONIC TONER

<p>PANASONIC TONER CARTRIDGE</p>

125

159

PHILIPS TONER

<p>PHILIPS TONER CARTRIDGE</p>

125

160

RICOH FAX CARTRIDGES

<p>RICOH FAX CARTRIDGES</p>

125

161

SAMSUNG TONER

<p>SAMSUNG TONER CARTRIDGE</p>

125

162

Toner Cartridges For Samsung Mono / Black Printers

<p>Samsung Toner Cartridges for Samsung Mono / Bla...

161

163

Toner Cartridges For Samsung Colour Printers

<p>Samsung Toner Cartridges for Samsung Colour Pri...

161

164

TALLY

<p>TALLY Toner Cartridge</p>

125

165

Tally T Series Toner Cartridges

<p>High Quality Tally Genicom Compatible Toner Car...

164

166

XEROX TONER

<p>XEROX TONER Cartridges</p>

125

167

Xerox Phaser Toner Cartridges

<p>High Quality Xerox Phaser Laser Toner cartridge...

166

168

Xerox Workcentre Toner Cartridges

<p>High quality Xerox Workcentre toner cartridges<...

166

169

Really Useful Boxes

 

1

170

ESET Smart Security

<p>&nbsp;ESET Smart Security</p>

46

171

Antivirus

<p><span style="font-size: medium"><span style="fo...

31

172

Antivirus

<p>

<meta content="text/html; charset=utf-8" http...

99

173

test again

<p>test again</p>

<p>&nbsp;</p>

31

174

test again 2

<p>tedtstxvhsghdb</p>

31

175

Smart Security

 

99

176

Home Entertainment

 

0

177

Blank Media Accessories

<p><strong>Blank Media Accessories</strong></p>

0

178

Compatible Ink for KODAK

 

5

179

SDHC CARD

 

109

180

Backpack

 

94

181

Briefcase Bags

 

94

182

Messenger Bags

 

94

183

Trolley Bags

 

94

184

Sleeve Bags

 

94

 

 

 

I think should help you more

Link to comment
Share on other sites

There are cat_id's that are the parents of themselves. There are cat_id's which the parents are the children of themselves.

 

Using phpMyAdmin, these are the records you must change:

 

cat_id: 7

cat_name: Printers

cat_parent_id: 0

 

cat_id: 30

cat_name: Printer Things

cat_parent_id: 7

 

cat_id: 8

cat_name: Software

cat_parent_id: 0

 

cat_id: 175

cat_name: Smart Security

cat_parent_id: 8

 

cat_id: 10, 31, 99, 171, 172, 173, 174 DELETE THESE RECORDS

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...