Hello André
> I am playing hard with mysql, cause my ultimate objective is to make a big > databank for a game. > > I notice that i cant find a way to make relations beteen tables. > Must i do it also with PHP ? Just to confuse you, the mathematical jargon for table is "relation"... May I suggest that you search the web for some tutorials on the use of SQL in general/MySQL in particular - it will help your playing, and ultimately your game. There are some RDBMS-es that implement SQL to the point of apparently setting up a construct that links tables - foreign key based data integrity being the first example that springs to (my) mind. However relational logic suggests that the way to set up a linkage between tables is to show this in dynamic logic - your SQL statement, eg SELECT * FROM tbl1, tbl2 WHERE tbl1.PrimaryKey = tbl2.ForeignKey; will produce a result-row for every intersection 'match' between the two tables. One of the MAJOR advances of relational databases over their predecessors was this move 'away' from structural 'connections'. However these have been maintained as 'features' by some, usually to promote speed/efficiency. Perhaps this is a major interest for you/gaming - but in which case, you will find that indexed-file systems will likely be a better/faster/smaller option. (?) An original objective, and one well worth bearing in mind today, is that relational technology allows one to establish a 'relationship' between items of data today, that was not anticipated/designed into the system when it was first built n-years ago. Flexibility! Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
