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, > name VARCHAR(64) NOT NULL, > members TEXT NOT NULL, > PRIMARY KEY (id,name), > ... >); > >CREATE TABLE att_type ( > id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL, > name VARCHAR(64) NOT NULL, > description TEXT NOT NULL, > PRIMARY KEY (id,name), > ... >); > >CREATE TABLE product ( > id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL, > category SMALLINT UNSIGNED NOT NULL, > name VARCHAR(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