Search engine results page problem

boba fett · July 12, 2010

My search engine is working beautifully to find the things that we want it to find. Problem is that when the results are displayed it displays the name, scientific name and common name for each returned entry. I would like to know how to get the titles to be displayed only once on the top of the page.

 <HTML>

<title>Search Engine</title>

My Search Engine.

</center>

</form>

</HTML>

<?php

//get data

$button = $_GET['submit'];

$search = $_GET['search'];

if (!$button)

echo "You didn't submit a keyword.";

else

{

if (strlen($search)<=2)

echo "Search not valid. Search term too short.";

else

{

echo "You searched for $search <hr size='1'>";

//connect to our database

mysql_connect("localhost:8888","root","root");

mysql_select_db("snakebook");

{

//explode our search term

$search_exploded = explode(" ",$search);

foreach($search_exploded as $search_each)

{

//construct query

$x++;

if ($x==1)

$construct .="Scientific_Name LIKE '%$search_each%'

OR Common_Name LIKE '%$search_each%'

OR Physical_Characteristics LIKE '%$search_each%'

OR Geographic_Range LIKE '%$search_each%'

OR Diet LIKE '%$search_each%'

OR Venom LIKE '%$search_each%'

OR Habitat LIKE '%$search_each%'

OR Notes LIKE '%$search_each%'

";

else

$construct .=" OR Scientific_Name '%$search_each%'

OR Common_Name LIKE '%$search_each%'

OR Physical_Characteristics LIKE '%$search_each%'

OR Geographic_Range LIKE '%$search_each%'

OR Diet LIKE '%$search_each%'

OR Venom LIKE '%$search_each%'

OR Habitat LIKE '%$search_each%'

OR Notes LIKE '%$search_each%'

";

}

//echo out construct

$construct = "SELECT * FROM specieslist WHERE $construct";

$run = mysql_query($construct);

$foundnum = mysql_num_rows($run);

if ($foundnum==0)

echo "No results found.";

else

{

echo "$foundnum result(s) found.<hr size='1'>";

while ($runrows = mysql_fetch_assoc($run))

{

//get data to display

echo "<center><table border='0' cellpadding='5' cellspacing='0'>

<tr>

<td>Thumbnail</td>

<td>Scientific Name</td>

<td>Common Name</td>

</tr>";

$common = $runrows['Common_Name'];

$scientific = $runrows['Scientific_Name'];

$thumbnail = $runrows['Thumbnail'];

//display data

echo "<tr>

<td>$thumbnail</td>

<td>$scientific</td>

<td>$common</td>

<td>

</tr>";

}

?>[/ php]

Pikachu2000 · July 12, 2010

If you move this

while ($runrows = mysql_fetch_assoc($run))

to just beneath this

</tr>";

You should be good to go, with one other minor fix. This line : <td> (it's the second to last line with any html in it) needs the closing and </td> tags added.

boba fett · July 12, 2010

Ok thats great, it has so far done what I wanted, Thank you. We are getting some interesting results, now it is doing 1 of 2 things its showing 23 of 1 result instead of 23 different results or it doesnt display properly at all.

Sign In

Search engine results page problem

Recommended Posts

boba fett

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

boba fett

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information