RE: [PHP] Help Needed

[David Skyers]

The following statement brings back nothing

select UPI, ORG from REDEP.UPI_WEB_DS where REC_VALUE = 'test'

The following statement brings back one row
select UPI, ORG from REDEP.UPI_WEB_DS where REC_VALUE = 'uczmdsk1'



-Original Message-
From: Angelo Zanetti [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2005 13:14
To: Raz
Cc: David Skyers; php-general@lists.php.net
Subject: Re: [PHP] Help Needed


does the actual SQL statement bring back any info if you do it through
the oracle interface, perhaps the problem isnt php but the SQL
statement. HTH

Angelo


Raz wrote:

>Leading back in the code, that would suggest that $nrows is not greater

>than zero - could be a problem with $nrows then, and anything 
>associated with that, i.e. $stmt, whether there is content in the db 
>where REC_VALUE = 'uczmdsk1' etc. etc.
>
>Work back down the chain and see if you can find anomalies...
>
>raz
>
>  
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Help Needed

[David Skyers]

Hi Raz

Good Point. It displays 'No data found' when it should display 'Data
found'

Thanks
David

-Original Message-
From: Raz [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2005 12:06
To: David Skyers
Cc: php-general@lists.php.net
Subject: Re: [PHP] Help Needed


David

>but it does not seem to be working.

Might be helpful for folks if you describe the nature of the fault i.e.
what you get back when you run this - at this stage there are a
multitude of possibilities...

raz

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Help Needed

[David Skyers]

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. 

 0) {

echo "Data found";

} else {

echo "No data found"; 

} 

?>

David

--
David Skyers
Support Analyst
Management Systems, UCL
[EMAIL PROTECTED]
020 7679 1849 (internal 41849) 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php