RE: [PHP-DB] Please help - Managing relational tables using PHP

You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database .... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ... However, you do not need to enforce constraints to have a relationship. I just assume that's what you're getting at. 2. Yes, if you enforce constraints with the CASCADE option it will. ...see same document: http://www.mysql.com/doc/en/SEC448.html ... Now the catch, my version of phpMyAdmin 2.3.0 does not allow me to choose the table type of InnoDB, even though my database is version 3.23.54. So I assume phpMyAdmin does not allow one to manage these attributes. Someone please correct me if I'm wrong. <>< Ryan -----Original Message----- From: Phanivas Vemuri [mailto:vas2u@hotmail.com] Sent: Thursday, January 02, 2003 12:50 PM To: php-db@lists.php.net; jason.selph@hp.com; opensource@phpwizard.net Subject: [PHP-DB] Please help - Managing relational tables using PHP hi all, 1. How does phpMyAdmin manage tables with "one to many" or "many to one" relation ships. Is there any documentation about this. --------------or----------------- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship. Thanks and Wish you a happy new year, Phani. _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php