Hi Guys,

I have this search:

PHP Code:

<?php 
include("../*********.php");
include("../*********.php");

# define simple variable from posted 'q' 
$q = trim(stripslashes(htmlspecialchars($_GET['q']))); 

# output no results found message
$XX = "No Record Found"; 

# start your query 
# using like to match with the % wildcards 

$query=mysql_query("select * from news where headline like '%%$q%%' or opening like '%%$q%%'") or die(mysql_error()); 


while($rows = mysql_fetch_assoc($query)) { 
echo '<a href="http://www.mysite.org/site/news/news.php?newsid='. $rows['newsid'] .'">'. $rows['headline'] .'</a><br>'; 
echo $rows['opening'].'<br><br>'; 
} 

//below this is the function for no record!! 
if ($q <= 0) 
{ 
print ("$XX"); 
} 

?>

...and it works, but even if it returns results it outputs the result and link then at the bottom 'no records found' even though it has? I don't see why though as the above I think **should** just say 'no records found' if that is the case?

Thanks

Chris

Instead of doing

PHP Code:

if ($q <= 0) 
{ 
print ("$XX"); 
} 


You might want to try something like this

PHP Code:

if (mysql_num_rows($query < 1)
{
print("$XX");
} 


What you are doing now is checking if the passed variable $q is <= 0, and you need to check for the results in the sql resource.