On Tue, 2002-06-18 at 19:53, Xuefer wrote: > 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 ? The id field makes handling rows much easier. > to remove a product > delete from attributes where product_id=$id > delete from product where id=$id Yep Cheers! -- "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