using empty row to trigger if

[tomycon]

Hello,

I'm trying to get an empty result from a postgresql query to trigger an "if" loop. More specific, I query the db for data on a specific item that if fact does not exist in the db, so "0 rows" are returned. What is the value to pass to php to start the if - else loop?

Here is a sample of the code:

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 ($rsltTEST == 0) {
                    echo "No job number exists.\n";
                    exit;
                    } else {

I'm sure there is a very simple answer to this but I haven't come across it yet! Thanks for your time and attention!

[redhead]

hmm.. could something like:

PHP Code:

if(!isset($rsltTEST)) || $rsltTEST === "") 


do it ??
I've never interacted with postgresql from PHP, so I'm not sure how the $rsltTEST will be formed, why not try and print it to the screen, so you'll know what to match for ?

[tomycon]

Thanks for the quick reply!

Printing to the page using:

PHP Code:

echo  $rsltTEST; 


shows up as "Resource id #3" ?!?

Your suggestion results in "Parse error: parse error, unexpected T_BOOLEAN_OR in ..."

I'm not sure what any of that means!

[redhead]

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 


[tomycon]

That works!
Your

PHP Code:

if (! ($row = pg_fetch_row($result))) 


did the trick! Just had to change it to "$rsltTEST".
Thanks for your perseverance and brainstorming!

[redhead]

For persistance I would suggest to use my last example where you query for how many rows the result holds, there you will not try to fetch any befor they need to be used.
Thus keeping every bit of info stored in your $rsltTEST untill needed, no matter if the result is NILL or more.

But what the hell, I'm drunk now, and it works