Hi guys,
this is the first time for me that I am trying to make some king of join between some MySQL tables.
I am used to work with MS-Access, and now I have some kind of mess in my mind about how to do same things in MySQL and PHP.
I have made some tables :
"Operating System" that take the os names
"Computer model" that takes records with PC model no.
and one last table called "Driver" that has many fields and in my intention it should refer for previous tables to get names of models and operating systems when later I will make a SQL query on it by PHP coding.
I want in other word to put the o.d. id number on the "Driver" OS field and the PC id on the "Driver" computer model field.
Has this a sense or how should I move ?
I need this in order to update SO and Models without the need to update the "Drivers" table or to have the risk to have uncorrelated records...
Could anybody give me some indications about ?
Many thanks
Fabio
this is the first time for me that I am trying to make some king of join between some MySQL tables.
I am used to work with MS-Access, and now I have some kind of mess in my mind about how to do same things in MySQL and PHP.
I have made some tables :
"Operating System" that take the os names
"Computer model" that takes records with PC model no.
and one last table called "Driver" that has many fields and in my intention it should refer for previous tables to get names of models and operating systems when later I will make a SQL query on it by PHP coding.
I want in other word to put the o.d. id number on the "Driver" OS field and the PC id on the "Driver" computer model field.
Has this a sense or how should I move ?
I need this in order to update SO and Models without the need to update the "Drivers" table or to have the risk to have uncorrelated records...
Could anybody give me some indications about ?
Many thanks
Fabio