trying to search in a single field and display results

salsa_dancer

I am trying to put together a search facility to find businesses by the city they are in. i have set up the database and can connect to it but what would I do to make a search box that would search a specific field in my table.... All the resources I seem to find don't work when i try to use them, maybe this is because I have to change some things and i am not quite sure what it all means yet...

The database is called 'dance' and the field is 'city'

Once it has found I need it to display them in the following format
Business_Name
Address
City
County
Country
Website

Have spent about 18 hours on this now and have manged to get nowhere.. Can anyone help me?

blindeddie

what database are you using. letme know and I can probably help.

Ed Warren

salsa_dancer

Using Mysql database and php... I got some code together but it just comes back saying it doesn't find any results :-(

blindeddie

post the code here and I will take a look at it.

salsa_dancer

OK when I try to run a search it doesnt seem to find anything... maybe I am going too complex here? Is there a simple way of doing this?

<?php

/ Get data from dBase /
echo "";
if ($num_rows == 0){
echo "No results were found, for this search. Please try different criteria.";
} else {
echo "Displaying $num_rows results, out of a possible $numero_rows.";
if ($num_rows != $numero_rows){
echo " \nView the complete result set <a href=\"$PHP_SELF?mode=full&by=$by&Salution=$Salutation&city=$city\">here</a>.";
}
}
echo " \n \n";

?>

<?php
echo "$data->business_Name";
?>
 

<?php
echo "$data->business_Name \n";
if ( $data->Address <> ''){
echo $data->Address;
}
if ($data->Address_2 <> ''){
echo ", ".$data->Address_2;
}
if ($data->Address_3 <> ''){
echo ", ".$data->Address_3;
}
if ($data->city <> ''){
echo ", ".$data->city;
}
if ($data->county <> ''){
echo ", ".$data->county;
}
if ($data->PostalCode <> ''){
echo ", ".$data->PostalCode;
}
if ($data->Country <> ''){
echo ", ".$data->Country;
}
if ($data->HomePhone <> ''){
echo " \nTelephone: ".$data->HomePhone;
}
if ($data->WorkPhone <> ''){
echo " \nTelephone 2: ".$data->WorkPhone;
}
if ($data->Salutation <> ''){
echo " \n Styles : ".$data->Salutation;
}
if ($data->website <> ''){
echo " \nWebsite: <a target=\"_blank\" href=\"$data->website\">".$data->website."</a> \n";
}

?>

blindeddie

you didn't include the SQL query that is pulling the data from the database.I need to see that to make sure it is correct. everything else looks fine.

salsa_dancer

<?php
/ MySQL database connection plug. /
$dbuser = "username";
$dbpass = "password";
$dbhost = "localhost";
$db1 = "dance";
if (isset ($errignore) && ($errignore == 1)){
$link = @mysql_connect( $dbhost, $dbuser, $dbpass );
} else {
$link = @mysql_connect( $dbhost, $dbuser, $dbpass ) or die("An error occured while establishing a database connection. Details of this are as follows: \r\n ".mysql_error()." Click <a href=\"$PHP_SELF?errignore=1\">here</a> to view the page anyway. Note: This may produce undesirable results.");

}
@mysql_select_db( $db1, $link );
?>

blindeddie

What I am seeing here is that you are not executng a SQL query that is pulling the data from the database. At a minimum you would need to select the data from the database to display
an example would be:

$result = mysql_query("select * from your_table_name where city = $city")

This would then give you a recordset of data that matched the value of the $city variable. I you are not performing a select, you are skipping the most important step.

salsa_dancer

This is what I am using on the search page

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<form name="form1" method="post" action="result.php">
<div align="center">
<table width="341" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="103"><img src="../gifs/search.gif" width="76" height="59"></td>
<td width="443">
<div align="center">Search our
Business Database - you can chose HOW to search, what
to search for, and even, WHERE to search.</div>
</td>
</tr>
</table>
 
</div>

      <table width="341" border="0" cellspacing="5" cellpadding="5" align="center" class="adTable" height="182">
        <tr> 
          <td width="175" height="2">&nbsp;</td>
          <td width="368" height="2">&nbsp;</td>
        </tr>
        <tr> 
          <td width="175" height="15"> 
            <div align="right"><font face="Arial, Helvetica, sans-serif" size="2" class="headerTxt">How?</font></div>
          </td>
          <td width="368" height="15"> <font face="Arial, Helvetica, sans-serif" size="2"> 
            <select name="by" >
              <option value="business_Name">Business Name</option>
              <option value="Salutation" selected> Style</option>
              <option value="city">city</option>
            </select>
            </font></td>
        </tr>
        <tr> 
          <td width="175" height="12"> 
            <div align="right"><font face="Arial, Helvetica, sans-serif" size="2" class="headerTxt">Search 
              For</font></div>
          </td>
          <td width="368" height="12"> <font face="Arial, Helvetica, sans-serif" size="2"> 
            <input type="text" name="city" size="30" >
            </font></td>
        </tr>
        <tr> 
          <td width="175" height="7"> 
            <div align="right"><font face="Arial, Helvetica, sans-serif" size="2" class="headerTxt">Search 
              Area</font></div>
          </td>
          <td width="368" height="7"> <font face="Arial, Helvetica, sans-serif" size="2"> 

            </font></td>
        </tr>
        <tr> 
          <td width="175" height="2"> 
            <div align="right"><font face="Arial, Helvetica, sans-serif" size="2"></font></div>
          </td>
          <td width="368" height="2"><font face="Arial, Helvetica, sans-serif" size="2"> 
            <input type="submit" name="Submit" value="Search Now" class="smallformbitsbutton">
            </font></td>
        </tr>
        <tr> 
          <td colspan="2" height="2"><font face="Tahoma" size="1">Note: In 
            the 'Search For' box, only single words will be matched. If there 
            is more than one word, or any spaces, you are less likely to get 
            good results.</font></td>
        </tr>
      </table> <div align="center"></div>
        </form>

</body>
</html>

blindeddie

please post a full copy of the result.php page that this form submission calls. That is the file that needs to pull the data

salsa_dancer

It is the 5th post down.. i see what you mean about me miising out the select option.. how would I integrate it into the results page so that it will show the information?

blindeddie

Instead of writing the code for you I suggest that you read the following article to get a better understanding of how to get the data out of and put data in a database.

http://www.databasejournal.com/features/php/article.php/10898_1469211_1

There are lots of examples and explanations that will help you.

salsa_dancer

lol... thanks will look at that tomorrow.. thanks for all your help.. I just wish i could get it to all tie together.. please tell me that I am not that far off now... It took me 3 months to work out how to connect to the database............

blindeddie

If you really get stuck, let me know, but please read that article first. You are getting closer!!! ;-)