josephman1988 Posted September 2, 2008 Share Posted September 2, 2008 Hey guys, I believe I've been related tables wrongly. So i'm now doing them the 'correct way'. Anyway, I have a 'games Table': games: gId (Auto_Increment + Primary Key) gName iTitle included: iId (Auto Increment + Primary Key) iTitle Now is this the correct way to 'relate' them? Link to comment https://forums.phpfreaks.com/topic/122442-relational-databases/ Share on other sites More sharing options...
cooldude832 Posted September 2, 2008 Share Posted September 2, 2008 u relate on primary keys/foreign keys so use iID (u can do full text but then the relationship sorta become useless) But yeah that's the basic idea. Link to comment https://forums.phpfreaks.com/topic/122442-relational-databases/#findComment-632271 Share on other sites More sharing options...
fenway Posted September 2, 2008 Share Posted September 2, 2008 But yeah that's the basic idea. That's the "idea"... but to use the non-PK is completely incorrect. Link to comment https://forums.phpfreaks.com/topic/122442-relational-databases/#findComment-632331 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.