Dropdown Category box with search field

mnewbegin

I have a search menu with a dropdown as the first box, and a text box as the second box to search some database records.

To what I know it works. But now I want to display those results after it chooses the correct part of the code.

The code is setup as Category 1, as first section and 2-18 as other

But I want to output my array of the found results below them. I tried to code it in, but then I break my IF/ELSEIF setup.

I guess I need to nest another IF, and output my array? between the original IF but before the ELSEIF?

heres my code, on my search.php page. A few variables are passed from the previous page.

productCat
and
search_text

<?php

 include('Includes/config.php');



//to save data from  html form into 2 variables
$productCat =  intval($_POST['productCat']);
$search_text = mysql_real_escape_string($_POST['search_text']);



//execute query
if ($productCat>1)
{
$query = "SELECT *, MATCH (prodName) AGAINST (".$search_text.") FROM `products` WHERE  MATCH (prodName) AGAINST(".$search_text.") AND `productCat`= ".$productCat." ORDER BY MATCH (prodName) AGAINST (".$search_text.") DESC";

$results = mysql_query($query);
}

elseif ($productCat==1)
{
$query = "SELECT *, MATCH (prodName) AGAINST (".$search_text.") FROM `products` WHERE  MATCH (prodName) AGAINST(".$search_text.") ORDER BY MATCH (prodName) AGAINST (".$search_text.") DESC";

$results = mysql_query($query);
} 


?>

big_nerd

mnewbegin,

I would recommend posting what you are trying to do, as your statement isn't entirely clear (to me at least)

You want to output your found results below their respective category?

I.e.

Category 1:
  Result
  Result
  Result
  Result
  Result
  Result

Category 2-18:

  Result
  Result
  Result
  Result
  Result

Do I have that right?

It would be best to post what you are trying to do as well..

mnewbegin

Here is my menu that the data is passed from.

I have a movie site that I'm trying to let users search movie titles for.

Theres 18 categories.

Category 1 is going to be to search my whole site. But havn't modified my code yet to work that way.

When they search if you leave the 1st box it searches mysite

but if you click the box it lets you search by category.

What I want to happen is when a search is submitted.

Have it show as.

Here are your results for Category Name: (CLICK HERE, to search the entire site.)

Result
Result
Result
Result
Result
Result

Here is the HTML for the form page.

the other code snippet I posted is for search.php

this is main.php

<html>
<body>


<center>

<br>
<br>
<img src="Header/logo_big.png">

<div id="search">
					<div id="search_1" ></div>
					<div id="search_2" >

					<form action="search.php" method="POST" name="searchForm" style="margin:5px" enctype="multipart/form-data" >

						<select name="productCat" style=" margin-left:10px; width:150px;">

							<option value="1">DiscBlu.com</option>
	<option value="2">Action & Adventure</option>
	<option value="3">Animation</option>
	<option value="4">Comedy</option>
	<option value="5">Documentary</option>
	<option value="6">Drama</option>

	<option value="7">Horror</option>
	<option value="8">Kids & Family</option>
	<option value="9">Military & War</option>
	<option value="10">Music Video & Concerts</option>
	<option value="11">Musicals & Performing Arts</option>
	<option value="12">Mystery & Suspense</option>

	<option value="13">Science Fiction & Fantasy</option>
	<option value="14">Special Interests</option>
	<option value="15">Television</option>
	<option value="16">Westerns</option>
	<option value="17">Adult</option>
	<option value="18">Gay and Lesbian</option>

						</select>

						<input name="search_text" type="text"  style="margin-left:10px; width:260px;" />

						<input name="button" type="submit" value="Search" style="margin-left:10px; padding-bottom:2px;  background:url(http://<?=$_SERVER['HTTP_HOST']?>/store/Header/Untitled-2_r2_c12.png) no-repeat; width:58px; height:20px; border:none; color:#FFFFFF;  "/>
					</form>

				</div>

				<div id="search_3" ></div>


			</div>

		</div>

	</div>

</center>

	</body>
	</html>

big_nerd

What I would do, and sorry I am short on time to provide a code example, but:

I would ORDER BY category FIRST (then your other MATCH order by's)

Then I would take the array result of the search from the entire site, and do something like

$oldcategory = "";

// assuming that $arrayResults is a multi-dementional array of search results, each value being an array (row from the table)

foreach ($arrayResults as $key => $val) {
   if ($val['category'] != $oldcategory) {
       $oldcategory = $val['category'];
       echo "<h2>{$val['category']}</h2>";
   }
   print_r($val);
}

So effectively you are storing which Category you've previously displayed from, and if its changed, reassign the $oldcategory variable (or previously displayed category) and then displaying the category header.

I hope this make sense...