[How to use Post and Get functions]

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.

 

<p align=\"center\"> <font size=\"3\">Select Operating System</font>

<select name=\"address\" size=\"1\" id=\"select4\">

<option value=\"Win98\" selected <?php if (!(strcmp(\"Win98\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Windows

98</option>

<option value=\"WinNT\" <?php if (!(strcmp(\"WinNT\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Windows

NT</option>

<option value=\"Win2K\" <?php if (!(strcmp(\"Win2K\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Windows

2000</option>

<option value=\"WinXP\" <?php if (!(strcmp(\"WinXP\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Windows

XP</option>

<option value=\"Win2003\" <?php if (!(strcmp(\"Win2003\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Windows

2003</option>

<option value=\"Novell\" <?php if (!(strcmp(\"Novell\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Novell</option>

<option value=\"OSX10.3\" <?php if (!(strcmp(\"OSX10.3\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Mac

OS X 10.3</option>

<option value=\"OSX10.2\" <?php if (!(strcmp(\"OSX10.2\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Mac

OS X 10.2</option>

<option value=\"OS9\" <?php if (!(strcmp(\"OS9\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Mac

OS 9.2</option>

<option value=\"OS8\" <?php if (!(strcmp(\"OS8\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Mac

OS 8</option>

<option value=\"OS7\" <?php if (!(strcmp(\"OS7\", $HTTP_POST_VARS[\'address\']))) {echo \"SELECTED\";} ?>>Mac

OS 7</option>

</select>

</p>

<p align=\"center\">

[Searching]

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.

[Searching]

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.

 

Field Type Null Default Links to Comments

Device varchar(30) No

Description varchar(120) No 0

Network_Name varchar(30) No

Location varchar(30) No

ip varchar(15) No 0

Can_Ping char(2) No

Drop varchar(4) No

Operating_Sys varchar(40) Yes NULL

quark50 varchar(5) No No

pic varchar(100) No nophoto.gif

quark41 varchar(5) No No

pm65 varchar(5) No

pm70 varchar(5) No No

quark60 varchar(5) No No

ps60 varchar(5) No No

ps70 varchar(5) No No

ps80 varchar(5) No No

ps90 varchar(5) No No

ps10 varchar(5) No No

pscs varchar(5) No No

ill9 varchar(5) No No

ill10 varchar(5) No No

corel10 varchar(5) No No

corel11 varchar(5) No No

wordperfect varchar(5) No No

publisher2000 varchar(5) No No

indesign1 varchar(5) No No

indesign2 varchar(5) No No

[Ill pay to get curl installed]

Did you ever get it installed?

[why the button cant work]

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

[Urgent help, please...:)]

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

[Primary Key and Unique confusion]

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.

[PHPMyAdmin troubles]

Did you get this problem fixed???

[dreamweaver]

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.

[Form Design Layout...]

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

[Searching]

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?