Warning: pg_exec(): Query failed: ERROR: relation "keywords" does not exist LINE 1: select * from keywords where keyword = 'tours' ^ in /home/gauteng/accommodation/search.php on line 31

Warning: pg_numrows() expects parameter 1 to be resource, boolean given in /home/gauteng/accommodation/search.php on line 32

Warning: pg_exec(): Query failed: ERROR: relation "keywords" does not exist LINE 1: insert into keywords (keyword,count) values ('tours',1) ^ in /home/gauteng/accommodation/search.php on line 35
   
                   

 

 

 
  Back to homepage

iExpo
Search ZA
Intoweb Applications
Intranets
Jobs
Website development

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."; } }*/ } ?>