Wednesday, February 27, 2008

phpAdmin v4 / v5

v4 doesn't allow you to visually create the relationships between the tables.
v5 does.

v5 is installed in the labs. Digiweb are running v4.
So, create you database locally then upload.

When you create your tables, you can select each one, click "relations view" and for each field, you can specify a table->field that it relates to.
You can also specify cascading updates and deletes from here.

NB:
if you built all this in access and use the script I mentioned in the previous post, it would handle all this for you anyway!

0 Comments:

Post a Comment

<< Home