Re: [PHP] can't retrieve more than 1 record at the time still

2009-12-15 Thread Catherine Madsen
Thank you so much for sending me in the right direction. I've re-written the first part of the script using PDO statements and it works great. Catherine Richard Quadling wrote: 2009/12/14 Catherine Madsen : Hi Again, Following the suggestions I received from a earlier post, I've closed

Re: [PHP] can't retrieve more than 1 record at the time still

2009-12-15 Thread Richard Quadling
2009/12/14 Catherine Madsen : > Hi Again, > > Following the suggestions I received from a earlier post, I've closed the > statement > while ($stmt->fetch(PDO::FETCH_BOUND)) > before $stmt = NULL; > I don't get an error anymore, but still retrieve only one record. > > To check that the array was bei

[PHP] can't retrieve more than 1 record at the time still

2009-12-14 Thread Catherine Madsen
Hi Again, Following the suggestions I received from a earlier post, I've closed the statement while ($stmt->fetch(PDO::FETCH_BOUND)) before $stmt = NULL; I don't get an error anymore, but still retrieve only one record. To check that the array was being filled correctly, I inserted in several

Re: [PHP] can't retrieve more than 1 record at the time

2009-12-09 Thread Paul M Foster
On Wed, Dec 09, 2009 at 11:39:55AM -0800, Catherine Madsen wrote: > Hi, > > I'm really in need of help. I'm not a PHP programmer, but I've been > given the privilege of customizing a script written by somebody else and > can't get it to work right. I have to query 2 different tables in 2 > diffe

Re: [PHP] can't retrieve more than 1 record at the time

2009-12-09 Thread Simcha Younger
On Wed, 09 Dec 2009 11:39:55 -0800 Catherine Madsen wrote: It looks like you have to take out this line: > $stmt = NULL; /* release the connection */ You are destroying the variable instead of just deleting the data, so the while statement terminates after the first record. -- Simcha Younger -

[PHP] can't retrieve more than 1 record at the time

2009-12-09 Thread Catherine Madsen
Hi, I'm really in need of help. I'm not a PHP programmer, but I've been given the privilege of customizing a script written by somebody else and can't get it to work right. I have to query 2 different tables in 2 different Oracle 10G DBs, one's mine (my_schema.my_table), the other (otherdb.