|
|
Posted by amygdala on 04/30/07 00:33
"mpar612" <mpar612@gmail.com> schreef in bericht
news: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
Navigation:
[Reply to this message]
|