drop-down box choice to retrieve data from db

[BettyJo50]

HI!!

I have a question/problem. I have a column in the database called Project. There are 3 projects...we'll call them A, B and C. I have created a drop-down box to choose one of them. After selecting one of the 3, I would like to display the records of the one project selected, but I'm not sure how to do that.

Here is some my code:

$SQL="SELECT * FROM SERVERREQUEST WHERE PROJECT='".$proj."'" ;

//drop-down box
<form name=&quot;form1&quot; method=&quot;post&quot; action=&quot;&quot;>
<select name=&quot;proj&quot;>
<option selected>Select.....</option>
<option value=&quot;A&quot;>A</option>
<option value=&quot;B&quot;>B</option>
<option value=&quot;C&quot;>C</option>
</select>
</form>

? if ($proj) { ?>
<table width=&quot;75%&quot; border=&quot;0&quot; cellpadding=&quot;3&quot; height=&quot;504&quot; align=&quot;center&quot;>
<tr>
<td colspan=&quot;2&quot; height=&quot;43&quot;>
<b>OASIS Vendor Server Registration</b>
<hr>
</td>
</tr>
//then the rest of the table

<? } ?>

</table>

Can someone please help me!?

THANK YOU!!!

 

[sleipnir214]

Insufficient data for a meaningful answer. Where does your knowledge of how to solve the problem end?


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BettyJo50]

Thank you.

 

[sleipnir214]

May I take it then that you don't need any help?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[BettyJo50]

I'm sorry! Yes, I believe I have figured it out.

THANK YOU!!!