when searches fail

[marty_arl]

how does one find out if the query didnt return any results in php (besides the Warning: Unable to jump to row 0 on PostgreSQL result index 2 ) stuff.
I know what line is causing the error;

$gotten=pg_fetch_row($result,0);
and i know that i cant check the value of result to see if the pg_fetch_row command will fail.

thanks
marty vw

[frog_]

Can you not do something like the example below? My example uses OCI commands, but they are mostly the same. This is just where my experience lies.

while (OCIFetch($sql_statement))
{
echo "<p>Inside while\n";
$job_title = OCIResult($sql_statement,1);
$job_desc = OCIResult($sql_statement,2);
echo "<li><b>$job_title</b> <BR><pre>$job_desc</pre></LI>\n";
}//end while

if (!$job_title)
{
print("<li>No current job openings</li>");
}

[[deleted]]

You may want to check the manual.
http://www.php.net/manual/en/function.pg-numrows.php

[kparker]

You need to check the return value of pg_exec(). If the query fails, it's null.

[[deleted]]

The subject is misleading.

The question was: how can I check if a query did not return any results.

[Anon]

If the query returns nothing, the value will be null, no in my example, the while loop wouldn't run as there was nothing to fetch. In the previous message by vincent, the function he mentioned wouldn't return anything. That is how you know.

[[deleted]]

If the query returns nothing, the value will be null

The value returned by pg_numrows($result) will be zero, but the result returned by the pg_exec() will not be NULL.

[kparker]

You are quite right, I looked at the subject and forgot what the original question was really about.

[[deleted]]

A "Homer's DOH!' moment :-)