Searching more than 1 field

[DSA_ADI]

Hi, I am a driving instructor in the UK and I am trying to make a directory of driving schools in the UK, Hopefully the driving schools will register with my website www.learnerdrivers.org.uk and learners drivers will search learnerdrivers.org.uk in hope to find there local driving instructor, I am using dreamweaver and have created a search results page, the problem is I only know how to search 1 field in the table, which at the moment is (postcodeb) I want to be able to search the rest of the fields (postcodea, postcodeb, postcodec, postcoded, townone, towntwo, townthree)

The code below is what dreamweaver generated.

<?php
$maxRows_myresults = 10;
$pageNum_myresults = 0;
if (isset($_GET['pageNum_myresults'])) {
  $pageNum_myresults = $_GET['pageNum_myresults'];
}
$startRow_myresults = $pageNum_myresults * $maxRows_myresults;

$colname_myresults = "-1";
if (isset($_GET['postcodeb'])) {
  $colname_myresults = (get_magic_quotes_gpc()) ? $_GET['postcodeb'] : addslashes($_GET['postcodeb']);
}
mysql_select_db($database_learnerdriving, $learnerdriving);
$query_myresults = sprintf("SELECT drivingschoolname, telephone, mobile, website, schoolemail, sellyourself, manual, automatic, passplus, motorway, adi, testcentre1, testcentre2, postcodea, postcodeb, postcodec, postcoded, townone, towntwo, townthree FROM holdadi WHERE postcodeb = '%s'", $colname_myresults);
$query_limit_myresults = sprintf("%s LIMIT %d, %d", $query_myresults, $startRow_myresults, $maxRows_myresults);
$myresults = mysql_query($query_limit_myresults, $learnerdriving) or die(mysql_error());
$row_myresults = mysql_fetch_assoc($myresults);

$query = "insert into adiusers (first_name) values ('".$SEARCHSTRING."')"; 

if (isset($_GET['totalRows_myresults'])) {
  $totalRows_myresults = $_GET['totalRows_myresults'];
} else {
  $all_myresults = mysql_query($query_myresults);
  $totalRows_myresults = mysql_num_rows($all_myresults);
}
$totalPages_myresults = ceil($totalRows_myresults/$maxRows_myresults)-1;
?>

I am not a programmer but I am learning a little as I go along…I am sure it is a very simple task to some. But not for me… Please Help.

Peter

[ ModEdit - bpat1434 ] Added php code tags.

[bpat1434]

Well, there are two ways to look at this:
1.) Search all fields for the search term
2.) Search the appropriate fields based upon user input

To search more than one field, you'd just modify the "WHERE" clause of the SQL query to be something like:
WHERE postcodea='%1$s' OR postcodeb='%1$s' OR postcodec='%1$s' OR townone='%1$s' OR towntwo='%1$s' OR townthree='%1$s'

Now, you could just plug that in, but what if they search for a town? Well, if they name a town, chances are there is no town name like: 12345, so you'd be searching a string. With postcode you'd be searching numbers. An easy way to identify that is like so:

<?php
// All the previous code cut to save space
$query_myresults = "SELECT drivingschoolname, telephone, mobile, website, schoolemail, sellyourself, manual, automatic, passplus, motorway, adi, testcentre1, testcentre2, postcodea, postcodeb, postcodec, postcoded, townone, towntwo, townthree FROM holdadi ";

if(ctype_digit($colname_myresults))
    $query_myresults .= sprintf("WHERE postcodeb = '%1$d' OR postcodec='%1$d' OR postcodea='%1$d' OR postcoded='%1$d'", $colname_myresults);
else
    $query_myresults .= sprintf("WHERE townone='%1$s' OR towntwo='%1$s' OR townthree='%1$s'", $colname_myresults);

// Continue on from here ....
?>

Those are just two options you have.

[DSA_ADI]

Thanks for that. But in the UK postcodes are a combanation of letters and numbers.

I have changed the code to WHERE postcodea='%1$s' OR postcodeb='%1$s' OR postcodec='%1$s' OR townone='%1$s' OR towntwo='%1$s' OR townthree='%1$s'

But now it don't work, Do I need to change any of the other code?

<?php 
$maxRows_myresults = 10; 
$pageNum_myresults = 0; 
if (isset($_GET['pageNum_myresults'])) { 
  $pageNum_myresults = $_GET['pageNum_myresults']; 
} 
$startRow_myresults = $pageNum_myresults * $maxRows_myresults; 

$colname_myresults = "-1"; 
if (isset($_GET['postcodeb'])) { 
  $colname_myresults = (get_magic_quotes_gpc()) ? $_GET['postcodeb'] : addslashes($_GET['postcodeb']); 
} 
mysql_select_db($database_learnerdriving, $learnerdriving); 
$query_myresults = sprintf("SELECT drivingschoolname, telephone, mobile, website, schoolemail, sellyourself, manual, automatic, passplus, motorway, adi, testcentre1, testcentre2, postcodea, postcodeb, postcodec, postcoded, townone, towntwo, townthree FROM holdadi WHERE postcodea='%1$s' OR postcodeb='%1$s' OR postcodec='%1$s' OR townone='%1$s' OR towntwo='%1$s' OR townthree='%1$s' " 
, $colname_myresults); 
$query_limit_myresults = sprintf("%s LIMIT %d, %d", $query_myresults, $startRow_myresults, $maxRows_myresults); 
$myresults = mysql_query($query_limit_myresults, $learnerdriving) or die(mysql_error()); 
$row_myresults = mysql_fetch_assoc($myresults); 

$query = "insert into adiusers (first_name) values ('".$SEARCHSTRING."')"; 

if (isset($_GET['totalRows_myresults'])) { 
  $totalRows_myresults = $_GET['totalRows_myresults']; 
} else { 
  $all_myresults = mysql_query($query_myresults); 
  $totalRows_myresults = mysql_num_rows($all_myresults); 
} 
$totalPages_myresults = ceil($totalRows_myresults/$maxRows_myresults)-1; 
?> 

Does the above code look ok

Thankyou, Peter