Then how about this:
PHP Code:
<?PHP
$dbconnO = pg_Connect ("dbname=contact_data user=httpd password=httpd");
if (!$dbconnO) {
echo "</table>A dbconnO error occurred.\n";
exit;
}
$rsltTEST = pg_Exec($dbconnO,
"SELECT job_no
FROM proj_contact
WHERE proj_contact.job_no = '$cntct_jno';");
if (! ($row = pg_fetch_row($rsltTEST))) {
echo "No job number exists.\n";
exit;
} else {
echo "Job exists " . $row['some_label'];
while($row = pg_fetch_row($rsltTEST))
echo "<br>" . $row['some_label'];
}
Or this:
PHP Code:
$rsltTEST = pg_Exec($dbconnO,
"SELECT job_no
FROM proj_contact
WHERE proj_contact.job_no = '$cntct_jno';");
if (! pg_num_rows($rsltTEST)) {
// nothing there