Forums

This topic is locked

Need Advise on DB & Recordset

Posted 14 May 2003 03:02:42
1
has voted
14 May 2003 03:02:42 Manou Manou posted:
Hi;
I need some advise on building an database and query.

I try to make a driver page on my website,so I decided to use DB, to be able to update the links for the home page and driver page when they changes and also viewer be able to search driver and of course I don't have to write company names double or more .

as you know there are some companies that manufatures couple of computer hardwares, like Acer that manufacutres CD ROM, Notebook, Monitore, Sound card, etc..
I have made a database parcially, but I am not sure how to to do the filtering or recordset so I thought to ask first, before I continue finnish the db.

here is how I did so far,
db has one table and these fields:

com_id, company_name, com_driver_page, com_home_page, cdrom, motherboard, monitor, harddrive, soundcard, etc...

the field of products like cdrom, motherboard, monitor... are set as Yes/NO,
so when inserting data into db, if a company manufactutes cd rom i just check mark under cdrom, and if it manufacures monitor as well, the monitor field will be checkmarked as well, and so on for the rest of the field.
and then continue with the next company on next row.

now if this db design is correct, how do i proceed with query.I have tried to make a recordset but have no idea how to deal with these Yes/No fields.

when on the page you click on the link of eg. CDROM then the page should show up only CD manufacturer of CD Roms.
I use DWMX, PHP, and MYSQL and PhAkt.
I appreciate your help.
Manou

Reply to this topic