Help Needed
| From: | David Skyers | Date: | Fri, 26 Aug 2005 11:00:39 +0000 |
| Subject: | Help Needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-221422@lists.php.net to get a copy of this message | ||
I have an annoying problem, I'm trying to write a simple PHP page that
says if a record is found in an Oracle database display 'Data Found'
else display 'No Data Found' but it does not seem to be working.
<?php
require("../passit.php");
$stmt = OCIParse("select UPI, ORG from WEB_DS where REC_VALUE =
'uczmdsk1'");
OCIExecute($stmt);
echo $stmt;
$nrows = OCIFetchStatement($stmt);
if ($nrows > 0) {
echo "Data found";
} else {
echo "No data found";
}
?>
David
----------------------------------
David Skyers
Support Analyst
Management Systems, UCL
d.skyers@ucl.ac.uk
020 7679 1849 (internal 41849)