If no results found

[7724]

Hi Guys,

Last bit of help with this searchscript I’m creating if I may please. The following script below performs a search and I ask it to say:

• If no seachstring entered output No searchstring was entered! – this works fine
• If no record found echo no results (this does it even if it finds results!) like so:

http://www.slougheaz.org/greenock/new_site/live_site/search/results.php?section=sport&searchstring=sport&Submit2=Submit

Can anyone please advise?

Thanks

<?php 

include("**********");

// Define Variable form 'First Query' post; 
$section = $_GET['section']; 
$searchstring = ($_GET['searchstring'] != "") ? $_GET['searchstring'] : false; 

// If nothing entered output message – THIS BIT WORKS
if($searchstring === false){ 
die("No searchstring was entered!"); 
} 

// If no matching record echo no results – this bit does not seem to work
if ($searchstring <= 0) { 
echo("No results!"); 
}

$query=mysql_query("select *, DATE_FORMAT(appeared, '%W %e %M %Y') as formatted_date from cms_stories where section like '%$section%' AND ( headline LIKE '%$searchstring%' OR body_text LIKE '%$searchstring%' )") or die(mysql_error());   

echo "<table width=\"100%\" border=0 bgcolor=\"#cccccc\" cellpadding=1 cellspacing=1>\n";  

echo "<tr> <th><DIV ALIGN=\"LEFT\">Type of Story</div></th> 
<th><DIV ALIGN=\"LEFT\">Appeared in Newspaper</div></th>  

<th><DIV ALIGN=\"LEFT\">Headline</div></th>  

<th><DIV ALIGN=\"LEFT\">Read Story</div></th> </tr>"; 

while($rows = mysql_fetch_assoc($query))   { 
  $story_id = (int)$_GET['story_id']; 
  if ($section == 'news') { 
      $filetype = "../news/story.php?story_id=" . $rows['story_id']; 
  } else if ($section == 'sport') { 
      $filetype = "../sport/story.php?story_id=" . $rows['story_id']; 
  } else if ($section == 'business') { 
      $filetype = "../business/story.php?story_id=" . $rows['story_id']; 
  } 
  echo "<tr BGCOLOR=\"#FFFFFF\"><td>"; 
  echo $rows['section'];
  echo "</td><td>"; 
  echo $rows['formatted_date']; 
  echo "</td><td>"; 
  echo $rows['headline']; 
  echo "</td><td>"; 
  echo '<a href="' . $filetype . '">[ more ]</a>';
  echo "</td></tr>"; 
} 
echo "</table>"; 

/* ======== END FIRST FORM SEARCH ======== */ 
?>

[ClarkF1]

if ($searchstring <= 0) {
echo("No results!");
}

This is before you've performed the query so how do you know how many results there are. Before the search there are always none so it will always display "No Results!"

[7724]

Hi,

Thanks for you help. I tried putting the statement in my query as well, so that runs first:

$query=mysql_query("select *, DATE_FORMAT(appeared, '%W %e %M %Y') as formatted_date from cms_stories where section like '%$section%' AND ( headline LIKE '%$searchstring%' OR body_text LIKE '%$searchstring%' )") or die(mysql_error());   

echo "<table width=\"100%\" border=0 bgcolor=\"#cccccc\" cellpadding=1 cellspacing=1>\n";  

echo "<tr> <th><DIV ALIGN=\"LEFT\">Type of Story</div></th> 
<th><DIV ALIGN=\"LEFT\">Appeared in Newspaper</div></th>  

<th><DIV ALIGN=\"LEFT\">Headline</div></th>  

<th><DIV ALIGN=\"LEFT\">Read Story</div></th> </tr>"; 

// If no record!!; 
if ($searchstring <= 0) { 
echo("No results!"); 
}

But still get the same problem?

Thanks

[thorpe]

Have a look at [man]mysql_num_rows/man.

[7724]

Nice!

I see now - thanks for pointing me in the right direction!

Chris