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:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 12:50 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to