Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: MySQL Answer

by screamingeagle (Curate)
on Jul 19, 2002 at 17:02 UTC ( #183312=note: print w/ replies, xml ) Need Help??


in reply to MySQL Answer

ummm...there are better ways to store the data .The database structure you currently have violates the First Normal Form of database design by saving category and subcategory in a single field. Here's a nice article about database normalization (Normalization)
I would recommend having a Category Table and a Subcategory table , the link between the both of them being the category ID , which would be the primary key of the Category table and the foreign key of the SubCategory table. Using such a strucure would mean that you would not need to use any parsing to get the data you want; all you would need is a simple SQL :

select c.*, sc.* from category c, subcategory sc where c.categoryID = sc.categoryID and categoryID = <the category you want>
This would get you all the data related to the category you're looking for as well as all the subcategories realated to that specific category


Comment on Re: MySQL Answer
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://183312]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (12)
As of 2014-10-20 08:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (74 votes), past polls