At 7:41 -0700 5/13/03, Carl B. Constantine wrote:
>* Paul DuBois (paul@stripped) wrote:
>> In your first query, you ran a SELECT. But apparently you didn't
>> actually fetch the results and free the result set. So the server's
>> still waiting for you to do that before you issue another query.
>> At least, that's what I'd guess based on the error message. It
>> should be sufficient to call mysql_store_result() and mysql_free_result()
>> before issuing the second query.
>
>Yes, just verified that worked last night. Thanks for the help!
>
>> >Paul, I have your first MySQL book. It's great. Thanks for writting it.
>> >I still have to pick up the second one though.
>>
>> Actually, there are three. :-)
>
><perks up> Oh really? What's the third one?
MySQL (now available in a second edition)
MySQL and Perl for the Web
MySQL Cookbook
Info available at URL in signature below...
--
Paul DuBois
http://www.kitebird.com/
sql, query
