-
1. Re: PHP/MySQL begginer: ? on SQL table relationships
Nancy O. Nov 15, 2010 12:47 PM (in response to TCarp)You'll get better answers to your PHP/MySql questions in the DW Development Forum
http://forums.adobe.com/community/dreamweaver/dreamweaver_development
Nancy O.
Alt-Web Design & Publishing
Web | Graphics | Print | Media Specialists
http://alt-web.com/
http://twitter.com/altweb -
2. Re: PHP/MySQL begginer: ? on SQL table relationships
TCarp Nov 15, 2010 12:52 PM (in response to Nancy O.)Thanks Nancy
I may have already answered one of my questions. Foreign key appear not to work with MyISAM (which is what I'm using) so they must not be critical for my purposes.
Tom
-
3. Re: PHP/MySQL begginer: ? on SQL table relationships
teedoffnewbie Nov 15, 2010 1:09 PM (in response to TCarp)Why not visit the MySQL forums at http://forums.mysql.com/index.php
Its a great forum with very good action and frequent posts. Not that you cant get MySQl answers here, but I like MySQL forums for MySQL questions.
-
4. Re: PHP/MySQL begginer: ? on SQL table relationships
David_Powers Nov 15, 2010 5:26 PM (in response to TCarp)TCarp wrote:
Foreign key appear not to work with MyISAMNot true. MyISAM supports foreign keys. What it does not support is foreign key constraints. There's an important difference.
A foreign key is simply the primary key of a record from another table stored as a reference. Foreign key constraints are SQL rules that determine what happens to the foreign key(s) when you update or delete records in the parent table.
When using MyISAM tables, you control what happens to the foreign key(s) through your programming logic (usually in PHP).
-
5. Re: PHP/MySQL begginer: ? on SQL table relationships
TCarp Nov 16, 2010 9:58 AM (in response to teedoffnewbie)Thanks, I'll do that. I've visited there to learn. I see they have a beginners forum.



