Well, you can use the "SQL" tab to write a sql statement to do whatever you
want, but no, the graphical interface doesn't appear to do that.
"Phanivas Vemuri"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED],
[EMAIL PROTECTED]
m> cc:
Subject: RE: [PHP-DB] Please help -
Managing relational tables using PHP
01/02/03 04:34 PM
Dear Mr. Ryan,
May be I did not present my question clearly to you. My question in detail
is ...
--> Does phpMyAdmin supports / allow / interface, editing data from "one to
many" or ,"many to many" related tables, using a single phpMyAdmin
interface( a single HTML page)
I have a (primary) table and one of its fields(category) has one or many
values , all these values are also listed in another(secondary) table. I
would like to know if phpMyAdmin provides any interface such that those
values from the secondary table appears(listed) (for example : as a Form)
in
the field of the primary table.
PrimaryTable(X,Y,category,Z) pk:X
SecondaryTable(category)pk:category
I am not intending to enforce referential integrity. My question is just
about the interfacing.
Thank you,
Phani.
>From: "Ryan Jameson (USA)" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: RE: [PHP-DB] Please help - Managing relational tables using PHP
>Date: Thu, 2 Jan 2003 13:32:15 -0700
>
>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
_________________________________________________________________
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
Niles Audio Corporation
This mail is confidential
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
