n00bish question

[b00n_saib0t]

i have a question moreso a problem,

im designing a system where people enter solutions to problems with software. a kind of knowledge base if you may..

i have two tables

the sql is as follows

create table software
(
 softwareid int unsigned not null auto_increment primary key,
 nameofsoftware char(20) not null,
 typeofsoftware char(15) not null,
 version char(10) not null,
 description char(25) not null,
 operatingsystem char(11) not null,
);

create table softwaresolution
(
 swsolutionid int unsigned not null   auto_increment primary key,
 solutiontype char(15) not null,
 solutionsummary char(20) not null,
 solution char(50) not null,
 dateofsolution char(7) not null,
);

how can i add or view solutions in PHP for a certain type of software?

e.g. view all the software solutions for Windows 2000 sigh

[ahundiak]

I believe you have a many-to-many relation between software and solutions. So you need a third table

software_softwaresolution
softwareid
softwaresolutionid

The third table has one record for each solution that a given piece of software provides. From there is a question of doing a join between the three tables. Read up on 'normalization' for more details.

[Steveo31]

SELECT * FROM software, softwareresolution WHERE operatingSystem = 'Windows 2000'

That should work, then do something like

while($row = mysql_fetch_assoc($queryAbove)){
    echo 'The Operating system is  '.$row['operatingSystem'].' and the solution is '.$row['solution']';
}