Search Page

Dada78

Hello again, I seem to be having trouble with calling information from another file. Here's the deal, I have a result.php page which contains all the information that one could search for. Now I have built a form that contains different search options. Now I have the form pointing at the result.php file to show the results of the search. For some reason I can't get it display the information of the search from the results.php file. If anyone could help me out on what I am doing wrong that would be great. If i need to post some script just let me know.

-Thanks in advance.

_theworks

hey,
ok lemmie get this straight... you wana search through a file with a html form?
but i am confused as to what you are searching?
you want to find certain words in theresults.php file?

please some more infomation or even code would help

msk_1980

post some code so that we can get some idea.

Dada78

Ok I have this page set up for testing but I will finish it out once I know I can get it working.

http://www.texascampingforum.com/2006/index.php?page=parks/advanced_search

That page is what will have the full form, as of right now it just has the one text feild.

Now I have this page which is the results page, I have renamed it listings page as it contains all the material I want to be searchable.

http://www.texascampingforum.com/2006/index.php?page=parks/listings

It's still being worked on so that's why things are off.

But I want to search

http://www.texascampingforum.com/2006/index.php?page=parks/listings

with the this form
http://www.texascampingforum.com/2006/index.php?page=parks/advanced_search

Here is the form basic:

<FORM  METHOD="GET" ACTION="?page=parks/listings">
<INPUT TYPE="text" NAME="name" SIZE="19"></font></td>
                </tr>
                  <INPUT TYPE="submit" value="Submit" style="float: right"></form>

Is thier some other script I need to add or something? Thanks for the help.

Dada78

Oh one more thing, When i entered a name on the search feild for example Cedar Hill, and hit search it comes out in the URL as

http://www.texascampingforum.com/2006/index.php?name=cedar+hill

but then redirects me to my home page and not the listings page with the results of the search.

_theworks

if you redirect a form with a search button on it to a page with stuff you want to search... its not going to search it...

you need to have the form point to a script like search.php or somthing use [man]strstr[/man] and other related functions..

change your html form to..

<FORM  METHOD="GET" ACTION="search.php">
<INPUT TYPE="text" NAME="name" SIZE="19"></font></td>
                </tr>
                  <INPUT TYPE="submit" value="Submit" style="float: right"></form>

Dada78

Thank you for your help, I think you are misunderstanding me as I am already doing what you suggested. Here is the results page.

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 8</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 9</title>
</head>

<body>
<?
include("dbinfo.inc.php");

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM parks ORDER BY name";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i <1) {

 $row = mysql_fetch_array($result);
$name = $row["name"];
 ;
?>

<div align="center">
  <center>
  <table border="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111" width="571" id="AutoNumber1" height="56">
    <tr>
                <td height="74">
                <p align="left"><font face="Arial" size="6" color="#74914F">
                <b>TEXAS CAMPGROUNDS, PARKS, &amp; LAKES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </b></font>
                <font face="Arial" size="1" color="#74914F">&nbsp;</font></td>
              </tr>
    <tr>
                <td bgcolor="#003366" height="1" width="634">
                <font face="Arial">
                <img src="file:///C:/Documents%20and%20Settings/Nick%20Copeland/My%20Documents/My%20Webs/2006/1.gif" alt border="0" height="3" hspace="0" vspace="0" width="634"></font></td>
              </tr>
    <tr>
      <td width="567" height="1"></td>
    </tr>
    <tr>
      <td width="567" height="1"><font face="Arial"><span class="cnnBigPrint">
            <span style="color: rgb(116, 145, 79)"><b>FIND A </b></span></span></font>
      <span class="cnnBigPrint"><font face="Arial" color="#74914F">
      <b>CAMPGROUND, PARK OR LAKE
      <br />
      </b>
      </font><font face="Arial">
      Texas Camping Forum offers information on over 800 parks including state &amp; 
      city parks, campgrounds &amp; RV parks and lakes for fishing, boating and 
      water sport activities. If you are looking for a particular place not 
      listed and you would like for us to include it. Then please feel free to 
      Contact Us and we will be more then happy to list it. We will be expanding 
      our database in the near future to include hunting ranches and other 
      hunting spots of interest. In the meantime select a location from below to 
      get more information.</font></span></td>
    </tr>
    <tr>
      <td width="567" height="1"></td>
    </tr>
    <tr>
      <td width="567" height="28">
      <font size="4">&nbsp; </font><p>
      </td>
    </tr>
    <tr>
      <td width="567" height="6">
      <font face="Arial Narrow" size="2">Your Search returned <b>(NUMBER) </b>
      locations<b> </b>that matched your criteria .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
      Search Again</font></td>
    </tr>
    <tr>
      <td width="567" height="24">
      </td>
    </tr>
    <tr>
      <td width="567" height="1" bgcolor="#DDDEC8">
      &nbsp;</td>
    </tr>
    <tr>
      <td width="567" height="1">
      <font face="Arial Narrow" size="3"><?echo "$name";?></font>
<?
$i++;
}

?></font></td>
    </tr>
    <tr>
      <td width="567" height="1">
      </td>
    </tr>
    <tr>
      <td width="567" height="1">
      <font face="Arial Narrow" size="2">&nbsp;</font></td>
    </tr>
    </table>
  </center>
</div>

</body>

</html>

Here is what it looks like without info.
http://www.texascampingforum.com/2006/index.php?page=parks/results

It echos info, just not when it's searched from from the DB.

I broke it downto one entry to make it easier to follow.

-Thanks

msk_1980

when they enter the name to search for and push search, the next form needs to display the results that got that name ..am i right?

Dada78

Yes that is correct.