PHP - Search Multiple Feilds With Multiple Words

First off, hello all!

I want to improve our website's search but unfortunately don't know enough to get there!

I'm not a PHP programmer but I'm generally able to tweak things... 

Our search page has 3 options - All words, Any word, Exact. 

I want to concentrate on the default "All words" which is the default parameter.

The code is essentially as follows -

Code: [Select]
$gotcriteria=TRUE;
$Xstext = mysql_escape_string($stext);
$aText = split(" ",$Xstext);
$aFields[0]="products.pId";
$aFields[1]="products.pName";
$aFields[2]="products.pDescription";
$aFields[3]="products.pLongDescription";
if($stype=="exact")
$sSQL .= "AND (products.pId LIKE '%" . $Xstext . "%' OR ".getlangid("pName",1)." LIKE '%" . $Xstext . "%' OR ".getlangid("pDescription",2)." LIKE '%" . $Xstext . "%' OR ".getlangid("pLongDescription",4)." LIKE '%" . $Xstext . "%') ";
else{
$sJoin="AND ";
if($stype=="any") $sJoin="OR ";
$sSQL .= "AND (";
for($index=0;$index<=3;$index++){
//$sSQL .= "(";
$rowcounter=0;
$arrelms=count($aText);
foreach($aText as $theopt){
if(is_array($theopt))$theopt=$theopt[0];
$sSQL .= $aFields[$index] . " LIKE '%" . $theopt . "%' ";
if(++$rowcounter < $arrelms) $sSQL .= $sJoin;
}
//$sSQL .= ") ";
if($index < 3) $sSQL .= "OR ";
}
$sSQL .= ") ";
}

Here's the important bit - as far as I can see, the search looks at each of the 4 fields in the array individually?  So if the search text is "RED APPLE", to get a result for the "All Words" option will require that both "RED" AND "APPLE" will need to be present in one of the searched fields...?

What I want to achieve is that if the product name is "RED FRUIT" and the description mentions "APPLE", then an "All words" search for "RED APPLE" will pick this up.

I'd guess that the easiest way would be to string the table fields together for searching but I don't know how to do this as a query... now I'm thinking I'll get flamed for not posting this in the MySQL forum too!! 

Thanks in advance for any help!

I've been trying to go around with str_replace to replace numbers with words.
I have a database which has table actions. The actions are saved in numbers from 0 to 20.
I'd need to get something to replace the numbers with words to explain what actions these are.

I've tried using this.
$action1 = str_replace("5", "Command", "action1");
But that doesn't work. Not even 100% sure if that is even correct, because I am new to the str_replace thing anyway.

Could someone help me with this, please?

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

Hi all

How do I modify the below code to search multiple tables in mySQL database?

$query = "select * from store_items where description like \"%$trimmed%\"  or title like \"%$trimmed%\" or dimensions like \"%$trimmed%\" order by id ASC";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

It is for a search function and I need it to search another table called 'about_text' and 'faq_text'

Thanks
Pete

How do I search through table 1, 2, 3 where a=x and b=y and c=z?

I am searching the database for items that are plaques. There are different years of plaques. I find all the plaques sorted by year. My display puts them in rows of 4 max.
What I want is to display them by year with a different year on a different line.
Right now there are 4 (1963), 3 (1965), 1 (1978) all bunched together.
1963, 1963, 1963, 1963,
1965, 1965, 1965, 1978

What I want is:
1963, 1963, 1963, 1963,

1965, 1965, 1965,

1978,

Any help would greatly be appreciated.


<?php
include 'config0.php';

$search=$_GET["search"];

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("$dbname")or die("cannot select DB");


$result = mysql_query("SELECT * FROM table1 WHERE plaques LIKE '%$search%' ORDER BY year") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';

// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 4;
    echo "<table align=center>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div style="float: left;">
          <div><img src="<?php echo $tn; ?>"></div>

  </div>


          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>

I'm looking to know the best way to process a search query that has multiple words in the search:

Code: [Select]
elseif(isset($_GET['search'])){
$search=$_GET['search'];
$keyword=explode(" ",$search);

//database query
}

Should I do a while loop query the database for each keyword?

I have 3 tables. 1)state(s_id, details);   2)univer(u_id,details,s_id);   3)sub(su-id,daetails,u_id, s_id)   Now there is a problem, for ever selection of state and univer there is multiple choice of sub and they can be common in different selections. And how to store these values in databse and can call in a selection menu. so how can i solve it?
Edited by N0name, 31 May 2014 - 10:38 PM.

Hi guys,   What I'm trying to accomplish sounds like fairly easy task but due to my poor knowledge of php this turned to be quite a challenge.    What I'm trying to do is to make a php script that will search the keywords on the multiple websites. Websites that I will search are all web shops, selling spare part for home appliances and keywords used are usually original spare part codes.   When searching, script is searching these websites using their own search functions and not Google or other search engines.   Input for this script should be a CSV file containing list of keywords and URLs of the web shops that needs to be search for all these keywords.

Here is the example:
http://prntscr.com/4ebhxh   Script should perform like this:

It picks up the 1st keyword, browse to the URL1, uses its search, searches for the product, if it finds it, copy its price and write it back to original input CSV. If it doesn't find match (search results appear empty) it should write "no match found" and continue to URL2, URL3 and so on... 

When all URLs from the list are checked for the 1st keyword, scripts picks up 2nd keyword and continues on through all these keywords are not checked.   This would be a resulting CSV file after the 1st keyword is checked:
http://prntscr.com/4ebj52

After all data from the input CSV file are processed, script should prompt a msg and create a download link for that CSV file to be downloaded.

If there are multiple matches, in other words if for one keyword some of the website searches find 2 or more products, something like "More then one match" should be written in the file. Example:

http://prntscr.com/4ebkcx

Please note that non of the website is using SSL and non of them requires login in order to display the prizes.
This fact should make this script easier to build.

Its not important for this script to run fast (its better I think to run it with some timeouts because of the server glitches and bottlenecks). What is more important is to make it automatic so one can start it over the night, over the weekends.

Number of the URLs would be around 10, and list of keywords from few tens, to a few hundred.    If I can provide some additional clarification and info I'm available. 
Of course I would be willing to pay someone to help me accomplish this task.

Cheers
Dean
Edited by dolke022, 19 August 2014 - 07:54 AM.

After a few days of searching and running across a problem what is almost like mine on these forums (cant seem to find the link now) where the person was looking to search a database using checkboxes.

What I am trying to do is use a list of checkboxes (http://www.animeseason.com/anime-list/categories/) exactly like this link and search my table which has the genres as columns.

I am new to PHP and don't really have a starting point. I have taken a bunch of examples and came up with this.

My HTML form with a list of all my checkboxes.
Code: [Select]
<form method="post" ACTION = "php/do_search.php">
                           <ul class="cat_col">
                               <li><input type="checkbox" name="cat_check[]" value="1"> <a href="#Action">Action</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="2"> <a href="#Adventure">Adventure</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="3"> <a href="#Comedy">Comedy</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="4"> <a href="#Demons">Demons</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="5"> <a href="#Drama">Drama</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="6"> <a href="#Ecchi">Ecchi</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="7"> <a href="#Fantasy">Fantasy</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="8"> <a href="#Harem">Harem</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="9"> <a href="#Horror">Horror</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="10"> <a href="#Magic">Magic</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="11"> <a href="#Martial Arts">Martial Arts</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="12"> <a href="#Mecha">Mecha</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="13"> <a href="#Music">Music</a></li>
                           </ul>
                            <ul class="cat_col">
                               <li><input type="checkbox" name="cat_check[]" value="14"> <a href="#Mystery">Mystery</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="15"> <a href="#Ninja">Ninja</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="16"> <a href="#Parody">Parody</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="17"> <a href="#Psychological">Psychological</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="18"> <a href="#Reverse Harem">Reverse Harem</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="19"> <a href="#Romance">Romance</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="20"> <a href="#Samurai">Samurai</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="21"> <a href="#School Life">School Life</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="22"> <a href="#Science Fiction">Science Fiction</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="23"> <a href="#Seinen">Seinen</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="24"> <a href="#Shoujo">Shoujo</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="25"> <a href="#Shounen">Shounen</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="26"> <a href="#Slapstick">Slapstick</a></li>
                           </ul>
                            <ul class="cat_col">
                               <li><input type="checkbox" name="cat_check[]" value="27"> <a href="#Slice of Life">Slice of Life</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="28"> <a href="#Sports">Sports</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="29"> <a href="#Supernatural">Supernatural</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="30"> <a href="#Thriller">Thriller</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="31"> <a href="#Tragedy">Tragedy</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="32"> <a href="#Vampire">Vampire</a></li>
                           </ul>
                           <ul class="cat_col">
                                <li><input type="checkbox" name="cat_check[]" value="33"> <a href="#Movie">Movie</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="34"> <a href="#OVA">OVA</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="35"> <a href="#Top Rated">Top Rated</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="36"> <a href="#Currently Airing">Currently Airing</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="37"> <a href="#Ended">Ended</a></li>
                                <li><input type="checkbox" name="cat_check[]" value="38"> <a href="#Ongoing">Ongoing</a></li>
                           </ul>
                      <div id="submit_btn_pos">
                      <input type="submit" name="search" value="Lets Make Magic" class="submit_btn">
                            <>
                        </form>

My PHP script that right now seems to do nothing.

Code: [Select]
<?php
//if we got something through $_POST
if (isset($_POST['cat_check'])) {
    $con = mysql_connect("localhost","USERNAME","PASSWORD") or die("Connection error");
mysql_select_db("DATABASENAME")or die("database doesn't exist");

// sanitize user input
$cleanData = array();
foreach($_POST['cat_check'] as $_comp) {
    //$cleanData = mysql_real_escape_query($_comp);
}

// Build query
  $compStr = implode("'), ('", $cleanData);
  $sql = "SELECT anime_name WHERE $_comp='1'";
  
}
?>
My database has a layout of "Name of show, (every genere listed above)".

Thanks for any help.

Hi guys,
 I have a php file that will go to a site and scrape the data I need. However this site is setup to use pagination so when I try to scrape all the players names I have to do separate queries to search each page. Is there a way to find out by using code how many pages there are and query all the pages at same time?

I use  this code
Code: [Select]
<?php //first page

//turn error reporting on
libxml_use_internal_errors(true);

//get data from this page
$dom = new DOMDocument;
$dom->loadHTMLFile('http://www.gametracker.com/server_info/76.73.3.42:1716/top_players/?searchipp=50#search');
$xpath = new DOMXPath($dom);

// Get the total player count
$rows2 = $xpath->query('//div[@class="block774"]/div');

// Get the rows from the search list
$rows = $xpath->query('//table[@class="table_lst table_lst_spn"]/tr');


for ($i=1; $i<$rows->length-1; $i++) {
    $row = $rows->item($i);

    // Get the columns for a row
    $cols = $row->getElementsByTagName('td');

// Get the player rank (1st column)
    echo 'Rank:'.trim($cols->item(0)->textContent).PHP_EOL;

    // Get the player name (2nd column)
    echo 'Name:'.trim($cols->item(1)->textContent).PHP_EOL;

// Get the player score (3rd column, actually 4th but number 3 is hidden)
    echo 'Sco '.trim($cols->item(3)->textContent).PHP_EOL;

echo "<br />";
}
?>





<?php //secondpage

//turn error reporting on
libxml_use_internal_errors(true);

//get data from this page
$dom = new DOMDocument;
$dom->loadHTMLFile('http://www.gametracker.com/server_info/76.73.3.42:1716/top_players/?searchipp=50&searchpge=2#search');
$xpath = new DOMXPath($dom);

// Get the rows from the search list
$rows = $xpath->query('//table[@class="table_lst table_lst_spn"]/tr');


for ($i=1; $i<$rows->length-1; $i++) {
    $row = $rows->item($i);

    // Get the columns for a row
    $cols = $row->getElementsByTagName('td');

// Get the player rank (1st column)
    echo 'Rank:'.trim($cols->item(0)->textContent).PHP_EOL;

    // Get the player name (2nd column)
    echo 'Name:'.trim($cols->item(1)->textContent).PHP_EOL;

// Get the player score (3rd column)
    echo 'Sco '.trim($cols->item(3)->textContent).PHP_EOL;
echo "<br />";
}

?>
I also have to go to that website first to see how many pages there are so I can have enough queries.

<?php

if(isset($_POST['ActivityId']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Activity like '%,$Search,%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

elseif(isset($_POST['EventId'])){

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from participation where EventId ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result)){

$LoginId= $row['LoginId'];

echo $LoginId;}

$query="select * from registration where LoginId='$LoginId'";

$result=mysqli_query($dbc,$query) or die('Not Connected to Reg');

while($row=mysqli_fetch_array($result)){

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}}



elseif(isset($_POST['Location']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Address like '%$Search%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}



elseif(isset($_POST['BloodGroup']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND BloodGroup ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

?>

<html><body><form action='<?php echo $_SERVER['PHP_SELF']?>' method="post">

<input type="text" name="Search"><br>

<input type="submit" name="ActivityId" value="Submit Activity Id"><br>

<input type="submit" name="EventId" value="Submit Event Id"><br>

<input type="submit" name="Location" value="Submit Location"><br>

<input type="submit" name="BloodGroup" value="Submit Blood Group"><br>



</form>

</body></html>




Hi frds.............
I have two tables named "registration" and "participation". Registration table have some columns like "LoginId", "email","contact no.", "Name" etc.and participation table have 2 column named "LoginId" and "EventId".
Now if user enters EventId, I want to display the details like email,contact no. etc.
I have a code but it not works properly.......
If result have more than one row it only displays the email and contact no. of last one instead of all.
Plzzzzzzzzz help anyone...................
????????/

Hey All,
 I'm trying to add multiple word search to my site and I'm getting the following error: "mysql_num_rows(): supplied argument is not a valid MySQL result resource " I know, my search is posting because I'm getting my search terms back with the "nothing found" message I have set up. Here's what I have:
Code: [Select]
  $search = $_POST["search"]; 
  $arraySearch = explode(" ", $search);
  $arrayFields = array(0 => "title", 1 => "content");
  $countSearch = count($arraySearch);
  $a = 0;
  $b = 0;
  $query = "SELECT * FROM table1 WHERE desc LIKE '$arraySearch'";
  $countFields = count($arrayFields);
  while ($a < $countFields)
  {
    while ($b < $countSearch)
    {
      $query = $query."$arrayFields[$a] LIKE '%$arraySearch[$b]%'";
      $b++;
      if ($b < $countSearch)
      {
        $query = $query." AND ";
      }
    }
    $b = 0;
    $a++;
    if ($a < $countFields)
    {
      $query = $query.") OR (";
    }
  }
  $query = $query.")";
  $query_result = mysql_query($query);

 
  if(mysql_num_rows($query_result) < 1)
   {
    echo '<p>No matches found for "'.$search.'"</p>';
  }
  else
  {
   Print "<table border cellpadding=3>";
    while($row = mysql_fetch_assoc($query_result))
    {
      Print "<th>Description:</th> <td>".$row['desc'].  "</td> ";
    }
 Print "</table> ";   
}

You guys are the best, thanks so much.

Hi,
So I'm trying to make a car rental project, and I need to show cars of a specific type, available in a specific period.
I'm currently using this query:
SELECT * FROM car, reservations
WHERE car.car_id = reservations.car
AND car.type = 1 AND reservations.reserved_from >= "2011-12-22"
AND reservations.reserved_to <= "2012-12-20";

So this returns all the cars of the type 1 reserved in 2011-12-22 - 2012-12-20 period.
So know that I know which cars are unavailable, how would you go ahead and pick out what's left?

I have a multiple choice search page which asks visitors to select one or more choices before rendering the search results. It only works in items 1+2 are selected, or 1+2+3, or 1+2+3+4, or 1+2+3+4, etc...

I want to make it so that any combination of choices work. Example: Items 1+6 or 2+3+5 or 1+4+6 etc...

I have four hours to fix it before my client shows up and need help BADLY.

Anyone out there who can help? Whoever can help me... you are the best and I will have a special prayer for you tonight.

Here is the coding:

<?php } else{
if(!empty($_GET['latt']) && !empty($_GET['long']))
{

$condition="SELECT ( 3959 * acos( cos( radians(  '".$_GET['latt']."' ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(  '".$_GET['long']."' ) ) + sin( radians( '".$_GET['latt']."' ) ) * sin( radians( latitude ) ) ) ) as distance,id,membership FROM notary_members ";

   if(!empty($_GET['s']))
   {
      $a=" where and";
   }
   else
   {
      $a=" where";
   }
   if($_GET['edoc']!='')
   {
      $condition.=$a." edoc= 'yes'";
   }
   if($_GET['esign']!='')
   {
      if($_GET['edoc']!='')
         $condition.=" and esign= 'yes'";
      else
         $condition.=$a." esign= 'yes'";
   }
   if($_GET['laserprinter']!='')
   {
      if($_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and laserprinter= 'yes'";
      else
         $condition.=" laserprinter= 'yes'";
   }
   if($_GET['dualtray']!='')
   {
      if( $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and dualtray= 'yes'";
      else
         $condition.=" dualtray= 'yes'";
   }
   if($_GET['error_in']!='')
   {
      if($_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and error_in= 'yes'";
      else
         $condition.=" error_in= 'yes'";
   }
   if($_GET['bg_checked']!='')
   {
      if($_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and bg_checked= 'yes'";
      else
         $condition.=" bg_checked= 'yes'";
   }
   if($_GET['home_insp']!='')
   {
      if($_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and home_insp= 'yes'";
      else
         $condition.=" home_insp= 'yes'";
   }
   if($_GET['fingerprint']!='')
   {
      if($_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and fingerprint= 'yes'";
      else
         $condition.=" fingerprint= 'yes'";
   }
   if($_GET['hosp_signing']!='')
   {
      if($_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and hosp_signing= 'yes'";
      else
         $condition.=" hosp_signing= 'yes'";
   }
   if($_GET['jail_signing']!='')
   {
      if($_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and jail_signing= 'yes'";
      else
         $condition.=" jail_signing= 'yes'";
   }
   if($_GET['im_docs']!='')
   {
      if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='')
         $condition.=" and im_docs= 'yes'";
      else
         $condition.=" im_docs= 'yes'";
   }
   if($_GET['jail_signing']!='' || $_GET['hosp_signing']!='' || $_GET['fingerprint']!='' || $_GET['home_insp']!='' || $_GET['bg_checked']!='' || $_GET['error_in']!='' || $_GET['dualtray']!='' || $_GET['laserprinter']!='' || $_GET['esign']!='' || $_GET['edoc']!='' || $_GET['im_docs']!='')
   {
    $condition.=" and status=1 order by distance asc";
    }
    else
    {
    $condition.=$a." status=1 order by distance asc";
    }

   $sql=mysql_query($condition);
   $num=mysql_num_rows($sql);
   $getmile=explode(' ',$_GET['miles']);
   
        $c=0;
        while($getidres=mysql_fetch_array($sql))
      {
          if($getidres['distance']<=$getmile[0])
        {
            if($getidres['membership']=='premium')
            {
            $prefirst[$getidres['id']]=$getidres['distance'];
            $c++;
            }
            else
            {
            $basicfirst[$getidres['id']]=$getidres['distance'];
             $c++;
            }
        }
        }
      
      if(!empty($sql))
     {
      
          if($c!=0)
         {
            if(!empty($prefirst) || !empty($basicfirst))
            { ?>