Hi , This is my first time here and I really was thrilled to see there is help. I need help with this , i have been stuck on it for the past 3 days. I am trying to create a search engine which will display all the records that are like the name they enter or in a given state if the user just selected a state, or all the records of the selected category if a user selected category, etc. When I select State and Category the code works, but it doesn't work for Name, and it doesnt work when I try to do searches on individual selections. I keep modifying my code but I still cant get it to work properly. Can someone please point me in the right direction. I really would appreciate any help I can get. Thank you sooooooo much in advance. <!---Forum Code above--> -------------------------------------------- <?php require_once('./mysql_connect.php'); //connect to the db. $var = @$_GET['business_name']; $var2 = @$_GET['category']; $var3 = @$_GET['state']; $limit=10; // Handle the form. // Create an empty new variable. if (isset($var)) { $business_name = TRUE; } // Check for a category. if (isset($var2)) { $category = TRUE; } if (isset($var3)) { $state = TRUE; } if (!isset($var) && !isset($var2) && !isset($var3)) { echo "<p>We dont seem to have a search parameter!</p>"; } if ($business_name && $category && $state) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND State =\"$var3\" AND Category =\"$var2\") ORDER BY Business_Name, City"; } elseif ($business_name && $category) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND Category =\"$var2\") ORDER BY Business_Name, City"; } elseif ($business_name && $state) { $query = "SELECT * FROM Users WHERE (Business_Name LIKE \"%$var%\" AND State =\"$var3\") ORDER BY Business_Name, City"; } elseif ($category && $state) { $query = "SELECT * FROM Users WHERE (Category = \"$var2\" AND State =\"$var3\") ORDER BY Business_Name, City"; } elseif ($business_name) { $query = "SELECT * FROM Users WHERE Business_Name LIKE \"%$var%\" ORDER BY Business_Name, City"; } elseif ($category) { $query = "SELECT * FROM Users WHERE Category = \"$var2\" ORDER BY Business_Name, City"; } else//if ($state) { $query = "SELECT * FROM Users WHERE State = \"$var3\" ORDER BY Business_Name, City"; } $numresults = @mysql_query($query); $numrows=mysql_num_rows($numresults); if(empty($s)) { $s=0; } $query .= " LIMIT $s,$limit"; $result = mysql_query($query) or die("Couldn't execute query"); echo "<p>You searched for:"" .$var . ", ". $var2 . ", ". $var3 . ""</p>"; echo "Results <br />"; $count = 1 + $s; while ($row=mysql_fetch_array($result)){ $title=$row[4]; echo "$count $title <br />"; $count++; } $currPage = (($s/$limit)+1); echo "<br />"; if ($s >= 1){ $prevs = ($s-$limit); print " <a href=\"$PHP_SELF?s=$prevs&business_name=$var\"><< Prev 10 </a> "; } $pages=intval($numrows/$limit); if($numrows % $limit){ $pages++; } if(!((($s + $limit)/$limit)== $pages) && $pages != 1){ $news = $s + $limit; echo " <a href = \"$PHP_SELF?s=$news&business_name=$var&category=$var2&state=$var3\">Next 10 >></a>"; } $a = $s + ($limit); if ($a > $numrows) {$a = $numrows;} $b = $s + 1; echo "<p>Showing results $b to $a of $numrows</p>"; ?> </body> </html>