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

2009-12-15 Thread Richard Quadling
2009/12/14 Catherine Madsen cmad...@berkeley.edu: 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

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 cmad...@berkeley.edu: Hi Again, Following the suggestions I received from a

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 cmad...@berkeley.edu 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. --

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 different