Simple PHP Search Help

[mat3000000]

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...

 

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

 

<?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.) $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 " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><<

  Prev 10</a>&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 " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";

  }

 

$a = $s + ($limit) ;

  if ($a > $numrows) { $a = $numrows ; }

  $b = $s + 1 ;

  echo "<p>Showing results $b to $a of $numrows</p>";

 

?>

 

[Pikachu2000]

What do you mean by "correct it"? What problems are you having with it?

[mat3000000]

What do you mean by "correct it"? What problems are you having with it?

 

Here is what it is saying when I run it...

 

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