//if search has been done
if (trim($search)!="")
{
$sql = "select * from gpages where ((' '||upper(metatitle)||' ') like upper(' %$search% ')) or ((' '||upper(title)||' ') like upper(' %$search% ')) or ((' '||upper(description)||' ') like upper(' %$search% ')) or ((' '||upper(description)||' ') like upper(' %$search% '))";
$result=pg_Exec($cms,$sql);
$numresults=pg_numrows($result);
if ($numresults == 0)
{
$sql = "select * from gpages where ((upper(metatitle)) like upper('%$search%')) or ((upper(title)) like upper('%$search%')) or ((upper(description)) like upper('%$search%')) or (upper(description) like upper('%$search%'))";
}
if ($numresults > 0)
{
$line=0;
print "$numresults tourism matches found |
";
print "\n\n";
while ( $line < pg_numrows($result) )
{
$row = pg_fetch_array($result,$line);
$resnum=$line+1;
$url=trim($row[url]);
$title=trim($row[title]);
$description=trim($row[description]);
$sql = "select * from info where name='$title'";
$rs = pg_exec($conn,$sql);
if ( pg_numrows($rs) > 0 )
{
$info = pg_fetch_array($rs);
$suburb = $info['suburb'];
}
print "$resnum. $title ($suburb)
\n";
print "\n";
print "$description
\n";
print "
\n\n";
$line++;
}
}
/* $sql="select * from searchengine where newentry=1 and (' '||upper(keywords)||' ') like upper(' %$search% ')";
$sql.=" order by priority";
$result=pg_Exec($conn,$sql);
$numresults2=pg_numrows($result);
//if there are results in the database then display them
if ($numresults2 > 0)
{
$line=0;
print "";
print "
$numresults general matches found |
";
print "\n\n";
while ( $line < pg_numrows($result) )
{
$row = pg_fetch_array($result,$line);
$resnum=$line+1;
$url=trim($row[url]);
$companyname=trim($row[companyname]);
$description=trim($row[description]);
print "$resnum. $companyname
\n";
print "\n";
print "$description
\n";
print "
\n\n";
$line++;
}
print "";
}
else
{
if ($numresults==0)
{
print "
";
print "No records matching your search requirements were found. Please try different criteria.";
}
}*/
}
?>