 |
||||||
|
||||||
|
";
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\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 " ";
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\n"; $line++; } print ""; } else { if ($numresults==0) { print " "; print "No records matching your search requirements were found. Please try different criteria."; } }*/ } ?> |
|||||