Posted by mpar612 on 04/30/07 20:27

On Apr 29, 8:33 pm, "amygdala" <nore...@noreply.com> wrote:
> "mpar612" <mpar...@gmail.com> schreef in berichtnews:1177882592.869930.194900@h2g2000hsg.googlegroups.com...
>
>
>
> > On Apr 29, 4:12 pm, "amygdala" <nore...@noreply.com> wrote:
> >> "mpar612" <mpar...@gmail.com> schreef in
> >> berichtnews:1177877211.921774.82090@h2g2000hsg.googlegroups.com...
>
> >> >> (assuming you posted all relevant code)
>
> >> >> You create a PDO instance $dbh, use it, and then you destroy the
> >> >> object:
> >> >> the next query can never be executed. Why the $dbh=null; ?
> >> >> Either strip those out of your code, or re-instantiate a PDO object
> >> >> before
> >> >> using it again.
>
> >> >> The object will automatically be destroyed by PHP when the script
> >> >> ends.
>
> >> >> HTH
>
> >> >> Sh
>
> >> > Thanks! I removed those $dbh=null; and still no luck. I know the SQL
> >> > statements are correct. They work perfectly in the code that I wrote
> >> > the code that uses the PEAR DB module. I have posted every bit of PHP
> >> > code that is on the page. All of the rest is just static HTML. Any
> >> > other thoughts? Thanks!
>
> >> What happens if you do a...
>
> >> try
> >> {
> >> $dbh->query('my query');}
>
> >> catch ( PDOException $e )
> >> {
> >> die( $e->getMessage() . ' on line: ' . __LINE__ );
>
> >> }
>
> >> ...for both queries?
>
> >> I suspect it could have something to do with buffered queries. I've had
> >> some
> >> occasions where I got error messages stating that I should use:
>
> >> $dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );
>
> >> .. because another query is not finished yet, eventhough for instance,
> >> only
> >> one
> >> row should be returned and I fetched that row already.
> >> I haven't given it enough attention yet, and just set the attribute to
> >> true,
> >> but it looks like it could be some bug.
>
> >> HTH
>
> > Thanks for the response! That didn't do anything, but return a blank
> > screen. I did a little playing around and the first statement works.
> > If I comment out that query and enter a hard value into the 2nd query,
> > it works. So, I think I need to figure out how to close the first
> > query so the 2nd query can execute. Does that make sense? Any
> > thoughts?
>
> > Thanks!
>
> Now that I took a closer look at the code, is this the following really the
> code you're using for the second query?
>
> $head_display = $dbh->query('SELECT headline_id,
> date, headline, headline_description FROM 10spot_headlines WHERE
> headline_id = $headline_id');
>
> If so, you should use " (double quotes), instead of ' (single quotes) to
> let PHP evaluates the variable $headline_id.
>
> HTH

Thanks! It actually turned out to be an issue with my end. You need
to end the query() before you can begin using another one. Got it
figured out. Thanks again!

[Back to original message]