PHP Search Page

[wiccanwoman1103]

OK I have a page that needs to search a database and return the results in the next page. how would i do that. I really need help. I am an intern and have a big project due. !!!!!!

[thorpe]

create a form that posts a string to search for. point this form at your result.php page, then in this page run a query something like.

$sql = "SELECT * FROM tbl WHERE fld LIKE '%{$_POST['searchstring']}%';";

[wiccanwoman1103]

this is what i have so far

<?php 
	mysql_connect ('localhost', 'uname', 'pass') or die (mysql_error());
	@mysql_select_db(helpdesk) or die (mysql_error());
	function getBuilding($campus){
		$result = mysql_query("SELECT description FROM building WHERE campus='".$campus."' ORDER BY description");       

		while($each = mysql_fetch_array($result))
			{
			echo "<option name=$each[description] value=\"$each[description]\">$each[description]</option>";
			}} 
	 ?>
	<?php 
	mysql_connect ('localhost', 'uname', 'pass') or die (mysql_error());
	@mysql_select_db(helpdesk) or die (mysql_error());
	function getDepartment(){
		$result = mysql_query("SELECT description FROM department ORDER BY description");       

		while($each = mysql_fetch_array($result))
			{
 		echo "<option name=$each[description] value=\"$each[description]\">$each[description]</option>";
			}} 
	?>
	<div id="content">
		<form name="helpdesk" action="admin_results.php" method="post">
		<table id="styled_form">
		<tr>
				<th class="section_heading" colspan="2"></th>
			</tr>
		<tr>
			<th>Work Order #:</th>
				<td><input type="text" name="num"></td>
			</tr>
			<th>Status:</th>
				<td><select>
						<option value = "">--</option>
						<option value = "submitted">Submitted</option>
						<option value = "open">Open</option>
						<option value = "closed">Closed</option>
						<option value = "completed">Completed</option>
						<option value = "suspended">Suspended</option>
					</select></td>
			<tr>
			<tr>
				<th>Requestor:</th>
				<td><input type ="text" name="user"></td>
			</tr>
			<tr>
				<th>Within Date Range:</th>
				<script language="JavaScript">
					function show_calendar(calendar_id) {
						eval("document.getElementById('" + calendar_id + "').style.display='inline'");
					}
				</script>
								<td><input type="text" name="date" size="10" maxlength="10" class="disabled_outline" onfocus="this.blur();" value= "" />
				<div id="date_calendar" style="position:absolute; height:150px; width:220px; z-index:100; background-color:transparent; display:none; ">
				<iframe src="../common/calendar.asp?FormName=helpdesk&amp;FieldName=date&amp"
					 frameborder="0" width="100%" height="158px" scrolling="no"></iframe></div>
				<a href="javascript:show_calendar('date_calendar');">&raquo; select begin date</a>
				<br><br>
				<script language="JavaScript">
					function show_calendar(calendar_id) {
						eval("document.getElementById('" + calendar_id + "').style.display='inline'");
					}
				</script>
								<input type="text" name="dateA" size="10" maxlength="10" class="disabled_outline" onfocus="this.blur();" value= "" />
				<div id="dateA_calendar" style="position:absolute; height:150px; width:220px; z-index:100; background-color:transparent; display:none; ">
				<iframe src="../common/calendar.asp?FormName=helpdesk&amp;FieldName=dateA&amp"
					 frameborder="0" width="100%" height="158px" scrolling="no"></iframe></div>
				<a href="javascript:show_calendar('dateA_calendar');">&raquo; select end date</a></td>
			</tr>
			<tr>
			<script type = "text/javascript">
				function showBuilding(obj)
					{	
						v = obj.value
						if (v == 'Alfred')
							{
								document.getElementById("select_campus_Alfred").style.display = 'inline'
								document.getElementById("select_campus_Wellsville").style.display = 'none'
							}
						if (v == 'Wellsville')
							{
								document.getElementById("select_campus_Alfred").style.display = 'none'
								document.getElementById("select_campus_Wellsville").style.display = 'inline'
							}
						}
			</script>
			<tr>
			<th>Location:<br></th>
				<td>
				<div class = left >Campus<br>
				<select onchange="showBuilding(this)" name="campus">
					<option value="Alfred">Alfred</option>
					<option value="Wellsville">Wellsville</option>
				</select> 
				 </div>
				 <div class = left STYLE="padding-left:5px">Building<br>
				<select id="select_campus_Alfred" name="building_alfred" style="display:inline;">
					<option value="">--</option>
					<?php getBuilding ('Alfred'); ?> 
				</select>  

			<select id="select_campus_Wellsville" name="building_wellsville" style="display:none;">
				<option value="">--</option>
				<?php getBuilding ('Wellsville'); ?>
			</select>  
			</div>
			<div class = left STYLE="padding-left:5px">Room/Area<br>
			<input type="text" name="room">
			</div>
			<div class = none></div>
			</td>
		</tr> 
		<th>Problem Type:</th>
			<td><select>
					<option value = "">--</option>
					<option value = "Administrative Access">Administrative Access</option>
					<option value = "Passwords">Banner Passwords</option>
					<option value = "E-mail">E-mail</option>
					<option value = "Hardware">Hardware</option>
					<option value = "Hard Wire">Hard Wire</option>
					<option value = "Network">Network</option>
					<option value = "Passwords">Network Passwords</option>
					<option value = "Software">Software</option>
					<option value = "Passwords">Sys-Reg</option>
					<option value = "Wireless">Wireless</option>
				</select></td>
		<tr>
		<tr>
			<th>Solution:</th>
			<td><input name="solution" type ="text" size="55"></td>
		</tr>
		<tr>
			<th>Details:</th>
			<td><textarea name="description" rows="7" cols="60"></textarea></td>
		</tr>
			<tr>
			<td class="form_submit section_heading" colspan="2"><button type="Submit">Continue</button>&nbsp; &nbsp; <button type="Reset">Clear Form</button></td>
		</tr>
	</table>
	</form>
</div>

This is the page that they will enter the information that they want to search for. How do i impliment what you said above into this page ?????