PHP - Simple Php Search Help

OK, I am new to PHP
I am wanting to create a property search using drop down boxes.
I have a database with 4 main fields to search: Bedrooms (beds), Area (area), Price Range (price) and Type (type)
Here is the code so far, can someone please correct it. Thanks...
******************************
When I run it it says:

Warning: trim() expects at most 2 parameters, 4 given in C:\wamp\www\search222.php on line 8

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\search222.php on line 45

Couldn't execute query

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<?php

  // Get the search variable from URL
  $var1 = @$_GET['beds'] ;
  $var2 = @$_GET['area'] ;
  $var3 = @$_GET['price'] ;
  $var4 = @$_GET['type'] ;
  $trimmed = trim($var1, $var2, $var3, $var4);

// rows to return
$limit=10;

// check for an empty string and display a message.
if ($var1 == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var1))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

$host = "localhost";
$username = "root";
$password = "";
//connect to your database ** EDIT REQUIRED HERE **
$link = mysql_connect($host, $username, $password) or die("Unable to connect to SQL Server"); //(host, username, password)

$db = "property_db";
//specify database ** EDIT REQUIRED HERE **
mysql_select_db($db, $link) or die("Unable to select database"); //select which database we're using

// Build SQL Query

$results = mysql_query("SELECT * FROM house_src", $link);
$numresults = mysql_num_rows($results);



// get results
  $result = mysql_query($results) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: ". $var4 . "property, with ". $var1 . " bedrooms, in the " . $var2 . "area, with a price range of " . $var3 ."";

// begin to show results set
echo "Results";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
 
?>

I found this amazing tutorial and i try to change it for a different database, but when i do a search it never finds anything.

<?php

$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'root'; 
$dbPass = '123';
$dbDatabase = 'ergasia2'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "&#927; &#972;&#961;&#959;&#962; &#945;&#957;&#945;&#950;&#942;&#964;&#951;&#963;&#953;&#962; &#960;&#961;&#941;&#960;&#949;&#953; &#957;&#945; &#949;&#943;&#957;&#945;&#953; &#941;&#967;&#949;&#953; &#960;&#949;&#961;&#953;&#963;&#963;&#972;&#964;&#949;&#961;&#959;&#965;&#962; &#945;&#960;&#972; 3 &#967;&#945;&#961;&#945;&#954;&#964;&#942;&#961;&#949;&#962;.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT Fname, Surname, StreetName, status FROM EMPLOYEES WHERE ";
      
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['Fname'])?"`Fname` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['Surname'])?"`Surname` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['StreetName'])?"`StreetName` LIKE '%{$searchTermDB}%'":'';
      
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
      
      if (count($types) < 1)
         $types[] = "`sbody` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
      
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `stitle`"; // order by title.

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['stitle']}<br />{$row['sdescription']}<br />{$row['sbody']}<br /><br />";
            $i++;
         }
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 
}
?>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
   <title>My Simple Search Form</title>
   <style type="text/css">
      #error {
         color: red;
      }
   </style>
   <body>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
         Search In:<br />
         Body: <input type="checkbox" name="body" value="on" <?php echo isset($_GET['body'])?"checked":''; ?> /> | 
         Title: <input type="checkbox" name="title" value="on" <?php echo isset($_GET['title'])?"checked":''; ?> /> | 
         Description: <input type="checkbox" name="desc" value="on" <?php echo isset($_GET['desc'])?"checked":''; ?> /><br />
                 Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
         <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
   </body>
</html>

The table which i use is the following
----------------
|EMPLOYEES|
----------------
|ssn             |
----------------
|Fname
----------------
|postal code |
----------------
|salary         |
----------------
|street name|
----------------
|street number |
-------------------
|surname      |
-----------------
|UnionMembershipNumber|
---------------------------------
|password     |
-----------------
|status         |
----------------

Hey all,
 
I need your help!
 
So, I am the web designer for a small company, but I use that term loosely as I for the most part am limited to design through Dreamweaver and Muse. I know a decent amount of HTML off the top of mey head, but when it comes to PHP, yikes...
 
My company asked me to make a simple searchable web page based on their price guide/catalog, built into their website. I have MySQL set up within their godaddy. I can use the SQL search functions to get the exact results back that I need, and the SQL cPanel gives me the following code:
 
SELECT * FROM `SMQSQL` WHERE `Scott` = '(Whatever I search for)' ORDER BY `LINEID` ASC
 
This makes sense to me up to here; this is very simple language, However, I have been pulling my hair out for days trying to get a simple search function as an actual PHP *PAGE* going.
 
Basically, I need to set up a PHP form search (not hard) that will go back and log in to my SQL database named SMQ (not too bad yet), perform a search out of a specific column named Scott (getting a little harder, and somewhat lost), take the search results from specific columns (getting harder), and display them in a neat little table (now I'm lost). My SQL database is set up with the following columns:
 
LINEID, Scott, Den, Color, Cond, 70, 70J, 75, 75J, 80, 80J, 85, 85J, 90, 90J, 95, 95J, 98, 98J, 100
 
Where LINEID is the index. LINEID is set to INT (5 char), the next 4 are TEXT (255 char, item descriptors), and the rest INT (9 char; prices).  When the results are displayed, I would like all but the LINEID visible.
 
I have tried and tried and tried playing with my PHP coding but am ready to shoot my computer.  Here it is:
 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Online Search</title>
</head>
<body>
<h3>Search Online</h3>
<p>You may search by Catalog number. Please use the exact Catalog number or you may receive an error. Please note that if searching for more than a basic item, include the full Catalog number WITHOUT spaces.</p>

<form  method="post" action="search.php?go"  id="searchform">
<input  type="text" name="Scott">
<input  type="submit" name="submit" value="Search">
</form>

<?php
if(isset($_POST['submit'])){
if(isset($_GET['go'])){
$Scott=$_POST['Scott'];;
 
  $db=mysql_connect  ("localhost", "guestuser",  "guestuser") or die ('Error connecting to the database. Error: ' . mysql_error());
      
      $mydb=mysql_select_db("SMQ");
 
      $sql="SELECT  Scott, Den, Color, Cond, 70, 70J, 75, 75J, 80, 80J, 85, 85J, 90, 90J, 95, 95J, P98, 98J, 100 FROM SMQ WHERE Scott LIKE '%" . $Scott .  "%';
 
  $result=mysql_query($sql);
 
  while($row=mysql_fetch_array($result)){
              $Scott=$row['Scott'];
              $Den=$row['Den'];
              $Color=$row['Color'];
              $Cond=$row['Cond'];
              $70=$row['70'];
              $70J=$row['70J'];
              $75=$row['75'];
              $75J=$row['75J'];
              $80=$row['80'];
              $80J=$row['80J'];
              $85=$row['85'];
              $85J=$row['85J'];
              $90=$row['90'];
              $90J=$row['90J'];
              $95=$row['95'];
              $95J=$row['95J'];
              $98=$row['98'];
              $98J=$row['98J'];
              $100=$row['100'];
    
      echo "<ul>\n";
  echo "<li>" . "<a  href=\"SMQ.php?id=$Scott\">"   .$Scott . " " . $Den .  " " . $Color .  " " . $Cond .  " " . $70 .  " " . $70J .  " " . $75 .  " " . $75J .  " " . $80 .  " " . $80J .  " " . $85 .  " " . $85J .  " " . $90 .  " " . $90J .  " " . $95 .  " " . $95J .  " " . $98 .  " " . $98J .  " " . $100 .  "</a></li>\n";
  echo "</ul>";
  }
        }
      else{
      echo  "<p>Please enter a search query</p>";
  }   
      ?>

I know it's probably pretty bad, but hopefully at least you can get an idea of what I'm trying to accomplish. Please dear God tell me what I am doing wrong! I'm sure it will take a knowledgeable user 5 minutes to fix this, but you would be saving my skin!
 
THANKS!!!
Edited by mac_gyver, 14 August 2014 - 11:04 AM.
removed link to op's cp and code tags please when posting code

hi iam trying to make a simple search form to search the members tables based on there input. iam new php so most of my code is guess work

Code: [Select]
<form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
<label for="country">Country:</label>
      <input type="text" name="country" />
      <label for="state">State:</label>
      <input type="text" name="state" />
      <label for="city">City:</label>
      <input type="text" name="city" />
      <input type="submit" value="submit" />
      </form>

<?

if ($_GET == array ()) {
//Define a variable that will be used to query the members; in this case, it would select all members
$query = "SELECT * FROM users";
} else {
//If the user typed at least one thing (in the form OR the url)
if (count ($_GET) == 1) {
//If what they typed is only for one criteria, define a variable that creates a query for only ONE criteria to search for
$query = "SELECT * FROM users WHERE 1";
foreach ($_GET as $field => $value) {
$query .= " AND $field = '$value'";
}
//If the user has typed in more than one field and hits search
} else {
//Define a variable for a query that selects members based off each criteria
$query = "SELECT * FROM users WHERE 1";
foreach ($_GET as $field => $value) {
$query .= " AND $field LIKE '%$value%'";
}
}

while($info = mysql_fetch_array( $data )) {

 Echo "<img src='http://datenight.netne.net/images/".$info['img'] ."' width='150' height='250''> <br>";

 Echo "<b>Name:</b> ".$info['username'] . "<br> <hr>";
 Echo "<b>Sex:</b> ".$info['sex'] . " <br><hr>";
 Echo "<b>Intrested in</b>" . "<br><hr>";
 Echo "".$info['rel'] . " ";
 Echo "".$info['frwb'] . " ";
 Echo "".$info['ons'] . " ";
 Echo "".$info['fr'] . "<br><hr>";
 Echo "<b>About me:</b> ".$info['aboutme'] . "<br><hr> ";
 Echo "<b>Looking for:</b> ".$info['looking'] . " <br><hr>";
 Echo "<a href='login_success.php'>'Back'</a>";

}
?>
    </body>
</html>

while($info = mysql_fetch_array( $data )) {  is not vaild error

i have enters some data using form which submit data in sql table1 like this,

Fields name in table -->>         id   First name     Lastname    Date   
data saved           -->>              1  user                1               2011-05-10
                                               2  user                2               2011-05-11
                                               3  user                3               2011-05-12

now i dont want to duplicate date in database let say while inserting data using form,

Firstname :  ____________
Lasename :  ____________
Date         :  ____________ (i dont want this date to b save if the date alredy exist in database,
                                          it should prompt user "Date already exist and to edit click here
                                         (this will be the link to that date which is already exist so that we can edit) " )

                                SAVE


i user  files ,       form.php ,   insert.php(so insert values in database) ,
so tell me what function should i use to solve my problem....