Yea i used it in one of my pages. Here is my source code. With .inc files and all.
-----search.php--------
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Search Me</title>
</head>
<body topmargin="0" leftmargin="0">
<form action="searchme.php" method="post">
<p align="center"><img border="0" src="searchourdb.jpg" width="174" height="44"></p>
<p align="center">Technology careers change at a growth rate which is far
beyond any other field of business. Accurate information unfourtunately
is not found in a book but is found on the internet. Our database has
been set up to give you the Category, Job Name, Education Level Needed,
Salary, Ability, And a brief job description. Please keep in mind that
this is simply an average, the salary levels and education levels may vary
upon job level.</p>
<table border="1" width="100%" height="133">
<tr>
<td width="16%" valign="top" bgcolor="#808080" background="TopNaviBackgroundBLUE.jpg" height="23">
<p align="center"><b><font color="#FFFFFF">Search:</font></b></td>
<td width="84%" height="23">Job Name:<select size="1" name="job_name">
<?php
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "select * from main order by 'job_name'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
include ("optiontag.inc"); printf("%s",$row["job_name"]); include ("afterinclude.inc");
printf("%s",$row["job_name"]);
print("</option>");
}
?>
</select></td>
</tr>
<tr>
<td width="16%" rowspan="3" valign="top" height="69"> </td>
<td width="84%" height="19">Education Needed:<select size="1" name="education">
<option value="Out Of High School (NO COLLEGE)">Out Of High
School (NO COLLEGE)</option>
<option value="2 Years College">2 Years College</option>
<option value="4 Years College">4 Years College</option>
<option value="Masters">Masters</option>
<option value="Doctorate">Doctorate</option>
<option value="5 Years Working Experience">5 Years Working
Experience</option></td>
</tr>
<tr>
<td width="84%" height="19">Salary:<select size="1" name="salary">
<option value="<=30"><30,000</option>
<option value=">=31,<=50">31,000-50,000</option>
<option value=">=51<=80">51,000-80,000</option>
<option value=">=81<=100">81,000-100,000</option>
<option value=">=101">>101,000</option>
</select></td>
</tr>
<tr>
<td width="100%" colspan="2" height="23" background="TopNaviBackgroundBLUE.jpg"><font color="#FFFFFF">Find
Anything:<input type="text" name="T1" size="28"> In
Category:<select size="1" name="incat">
<option value="type_bus">Type Of Business</option>
<option value="job_name">Job Name</option>
<option value="education">Education</option>
<option value="salary">Salary</option>
<option value="ability">Abilities Needed</option>
<option value="job_desc">Job Description</option>
<option value="other">Other</option>
</select></font></td>
</tr>
</table>
<p><input type="submit" value="Search" name="search"></p>
</form>
</body>
------end search.php-------
------optiontag.inc----
<option value="
------end optiontag.inc---
------afterinclude.inc----
">
------end afterinclude.inc----
That is how I did it. I am sure there are other ways. But it works for me. It makes the drop down menu with the appropriete values. Just let me know if you have any questions.
