Rheal

Dont know if this is what you want ....but just copy paste this between Form tags and it should give you a Idea how I would do what you are trying to do.

On the page with the pull down list I have to setup a variable. When I select the value from the pull down list it gets assigned to the variable also. The search query should look something like this I think.. Select ($Variable) From lab Where ($Variable) = yes This is what I think the query should be like but I dont know how to write the real code...CAN you help.

I am stuck on this project and cannot go any further without your help. Let me explain it again. I have appx 20 fileds named after programs which may be installed on a computer. The fiels can contan either yes or no. I want to creat a page with a puldown list where you select the program you want to use and it will goto a page that will display a list of computers tha t have this program installed. This would be find if I had only one field to searcd but I have appx 20 fields. it has to first find the program field and see if a yes is in that field. I dont know how to code it to look for that field only to see if it contains a yes. Please I am at a standstill without this. I have included the list of fields below.

Did you ever get it installed?

Your button has to be placed somewhere between the 2 form tags <form> place submit button here </form Dreamweaver dose this for you...shouldnt be too hard

Check the ip address on your pc and see if it matches..you may be on a dhcp connection and your ip and the network ip may be differant

All the primery key is for is to tell the database which Field for it to sort on. The database can be sorted using various fields but the primiary key is the first field to sort.

Did you get this problem fixed???

Treat PHP pages just like you would treat HTML pages...they go into the same folders....they do not reside in the CGI-Bin folder. After you created your test.php and put this file in the same folder as all your html pages access it with your browser using the URL to your webserver....http://ip.address.of.your.webserver/test.php If you are still getting errors paste your code here so we can see where you may have went wrong.

You can be quite creative with DW when it comes to placement, Try using tables. But just like everythigh there are limits.

I have a MySql database where I have a seperate field for each program \"Quark, Pagemaker, Photoshop, ect\" that may be on a certain computer. The value for each field is either Yes or No. Meaning yes its installed on the computer or No its not. I want to create a page with a pull down list where I select the program leys say \"quark\" and it would bring me to a detail page listing all the computers that have Quark installed \"Yes\" I understand how to do this if I was checking one field for yes or no , but because i have numerous fields i cand seem to come up with the code to do this. Is there anyone out there who can help?