cateogry.members a list of att_type_id, right?
and also displayOrder
i got it. it's nice :)
but is it a must to have attributes.id ?
unique id (product_id,att_type_id) is not enough ?
to remove a product
delete from attributes where product_id=$id
delete from product where id=$id
On Tue, 2002-06-18 at 19:02, Xuefer wrote:
sorry, i can't quite get what u meant
dunno how to do as u said
You might want to associate the attributes with categories
in a different table. This way you could put an attribute
into multiple categories. You could also specify the displayORder
in the category table as well.
Hi Xuefer,
No problem - sometimes code is the best explanation! :)
Here are the rough tables for what I described - they *may* work! :)
CREATE TABLE category (
id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
nameVARCHAR(64) NOT NULL,
members TEXT NOT NULL,
PRIMARY KEY (id,name),
...
);
CREATE TABLE att_type (
id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
nameVARCHAR(64) NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id,name),
...
);
CREATE TABLE product (
id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
categorySMALLINT UNSIGNED NOT NULL,
nameVARCHAR(64) NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (id),
...
);
CREATE TABLE attributes (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
product_id MEDIUMINT UNSIGNED NOT NULL,
att_type_id SMALLINT UNSIGNED NOT NULL,
value VARCHAR(64) NOT NULL
PRIMARY KEY (id),
...
);
Good Luck!
--
Gosh, Batman. The nobility of the almost-human porpoise. --Robin
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate
/_/ /_/\_, /___/\___\_\___/ Calgary, Canada
___/ www.mysql.com
Feed the Dolphin! Order MySQL support from the MySQL developers at
https://order.mysql.com/?ref=mzgr
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php