RE: [PHP-DB] Please help - Managing relational tables using PHP
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
[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
RE: [PHP-DB] My question in precise reg PHP and relational tables.
hi, I have added my question , my main Aim at the end of this explanation. I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using PhpMyAdmin as the interface for the mySql Database. The PhpMyAdmin uses a text filed to show the values of the category. If there are two or more categories for example Beef and Diary then"Beef | Diary" is shown in the text field. Now I want to change that text field into a drop down list and enable multiple selection of the values. And if I want to update the category field in program clips I will select one or more values in the drop down list and do some programming to put a pipe symbol in between the selected values ( in order to make MySQL to understand and interpret). :: My Question in Precise is 1. is there aby way in realation databases that the values that appear in the FORM are the values from the 'categories' table. If I add more categories then those values can be automatically added into the FORM from whcih I update the 'category' field in 'programClips' table. _ 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
Re: [PHP-DB] here's my problem in PHP & relational tables
hi, I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using PhpMyAdmin as the interface for the mySql Database. The PhpMyAdmin uses a text filed to show the values of the category. If there are two or more categories for example Beef and Diary then"Beef | Diary" is shown in the text field. Now I want to change that text field into a drop down list and enable multiple selection of the values. And if I want to update the category field in program clips I will select one or more values in the drop down list and do some programming to put a pipe symbol in between the selected values ( in order to make MySQL to understand and interpret). But my Problem is ... how to say to PhpMyAdmin that u change this particular field a drop down. How to do that in a general sense, so that it does that always when I use the values which are unique in another table. Any idea... if u donot understand my problem ... please mail me ... I will try to be more clear. Advance Thanks for the patient people, Phani. From: Brad Bonkoski <[EMAIL PROTECTED]> To: Phanivas Vemuri <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] newbee in PHP-MySQL- help in relational tables Date: Sun, 15 Dec 2002 19:11:04 -0500 I would say, that MYSQL is a relational database, thus implying that tables would eb relational and this is a DB forum, so just shot, what's the problem? Phanivas Vemuri wrote: > hi, > I need to knwo if anyone had worked on a php interface for relational tables > in MySql. I have a problem , would be explaning the problem after anyone > responds. > Thankyou, > Phani. > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > 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 _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] newbee in PHP-MySQL- help in relational tables
hi, I need to knwo if anyone had worked on a php interface for relational tables in MySql. I have a problem , would be explaning the problem after anyone responds. Thankyou, Phani. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] A help on relational databases using php
hi all, i need some help regarding soem one who had worked on relational databases suing php as the interface. Phani. _ MSN 8 helps eliminate e-mail viruses. Get 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-DB] Help on MySql Relational Tables
hi all, I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using PhpMyAdmin as the interface for the mySql Database. The PhpMyAdmin creates a text filed to show the values of the category. Where as I want to replace the text field to put a drop dwon list which can select multiple categories. There is no relation between the two tables. Can any one help me how to do that. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
