5 Replies Latest reply: Nov 16, 2010 9:58 AM by TCarp RSS

    PHP/MySQL begginer: ? on SQL table relationships

    TCarp Community Member

      I recognize this is a DW forum so if someone has a MySQL on of equal quility, I'd love the link.

       

      However, there's a lot of PHP and MySQL knowledge here, so....

       

      I'm a PHP/MySQL/Form beginner and have a novice understanding of MS Access.  I have a little volunteer project where the capabilities will fit in so I have a good, safe project to learn on.

       

      I have the forms coded (although not yet linked to PHP/MySQL).  I've also successfully learned how to create tables using SQL CREATE.  The next steps are to 1) set up the table relationships and 2) figure out SQL statements for the table fields.

       

      In Access, joins are created on the relationships user interface and I pretty much understand the basics of how to create them.  I noticed there are JOIN commands in MySQL along with the ability to set foreign keys in the tables so I assume that's the equivalent.

       

      In MySQL does the JOIN make a stored change or is it only for the duration of the transaction (PHP)?  Are specifying the foreign keys required to make things work?

       

      In Access, I'd specify the attributes of fields via the table user interface including binding, etc.  How is that done in MySQL?

       

      Thanks

       

      Tom