Create new table will have relationship to prime table automatically

[Sigmahokies]

Hi everyone,

I know how to create new table by PHP, but I don't know how to have relationship to prime table such as account or register table once a new table is insert. Can you please show me how to do that? I know how to create new table, but my point is once table is insert in phpmyadmin, then have relationship connect to prime table. If you are not sure, I will explain more about this. 

Thanks,

Gary

[justsomeguy]

Assuming you're using InnoDB and MySQL, you add foreign key constraints either when you create the table, or later using an ALTER TABLE query.

https://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html

[Sigmahokies]

Actually, I am using MySQL (MariaDB), All right I will try this, I will come back to comment if I have something wrong or question.

Thanks,

Gary

[justsomeguy]

I'm talking about the storage engine used for the tables.  InnoDB supports foreign keys, MyISAM does not.  Your MySQL tables are probably using one of them, only InnoDB will enforce those constraints.