PHP/MySQL Miscount

[Leisa]

Hello. My site contains categories and sub-categories of information. When you click on a category, the number of records matched is displayed next to the sub-categories that come up. But, something has gone screwy. When you go to view those records, the number of results is not the same. Now, this isn't happening everywhere, only for a few sub-cats.

For example, go to http://supplierlocator.com/1001.php and look at the first sub-category "General Apparel, Accessories, etc.". The number of records is 15. When you click on the sub-cat you can see the number of records returned is only 14.

I haven't touched the code for this aspect of the site since I finished working on it a year ago. It was fine before. The only thing I do on a regular basis is back-end database maintenance. It has to be something I'm doing when I modify records in the database. I could use some guidance!

[cyanide]

Hi Leisa,

It's a little difficult to say without looking at the code or database.
However, since you haven't messed with the code and this problem hasn't occurred anywhere else...

Lemme throw a few things out...
Have you tried to track down the table that calls this category? -to maybe find this mysterious 15th.

Could it be that a new registrant accidentally clicked the register button without filling out all fields? The main category could recognize this as a numbered id, but the sub-cat doesn't recognize it because it might be calling the entries by company name, which in this case doesn't exist?

oh man, I was thinking of something else as well, but alas ... lost my train of thought

[Leisa]

Originally Posted by cyanide

Have you tried to track down the table that calls this category? -to maybe find this mysterious 15th.

While digging for the answer to the above question, I discovered that there are actually 16 records that match Apparel>General Apparel...Hmmm...Digging deeper...

[Leisa]

I got it and oh man do I feel stupid. Well, I had deleted one part of a record for a listing but not the other...so, it matched the sub-cat query but didn't have everything it needed to be shown the sub-cat results display. Um, hard to explain. Thanks cyanide!!!!

[cyanide]

Originally Posted by Leisa

I got it and oh man do I feel stupid. Well, I had deleted one part of a record for a listing but not the other...so, it matched the sub-cat query but didn't have everything it needed to be shown the sub-cat results display. Um, hard to explain. Thanks cyanide!!!!

glad yougot it figured out !!
actually, that was what I was trying to spit out.
You're right, hard to explain, but it depends on which field the script is calling.

Your welcome