Hi
Thanks for all the responses. However I am still stuck for a MySQL db I
can create
and code in PHP. Attached is a brief example of data to be used.
One problem I have is with providing a listing that includes ...
WTBC (Category without SubCats) and the 3 Zones (also, Cats without
SubCats ??? )
(This is for a complete WTBC listing, in practice it may list depending on
selected Zone)
The example Schema is interesting, but is there another way of storing all
links
in one table and join them to Category and SubCat tables ?
An example of the ER Diagram would also be helpful to me.
cheers
----- Original Message -----
From: "John Meyer" <john.l.me...@gmail.com>
To: "BobSharp" <bobsh...@ntlworld.com>
Cc: <mysql@lists.mysql.com>
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There will be some sub-categories.
eg: Organistions will have ... Zones of WTBC, National Organisations
within
the Zones, UK organisations, Disabled Bowling organisations, ...
eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues,
etc.
Can anyone suggest how I should set out tables for this database ?
Here's one suggestion
Table:
URLs:
URL_ID
URL_TEXT
CATEGORY
CATEGORY_ID
CATEGORY_TEXT
SUBCAT
SUBCAT_ID
CATEGORY_ID
SUBCAT_TEXT
URL_CATEGORY
URL_ID
CATEGORY_ID
SUBCATEGORY_ID
PK: (URL_ID, CATEGORY_ID)
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.72/2337 - Release Date: 08/31/09
05:50:00
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
