List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 20 2011 5:45am
Subject:Re: running a mysql query inside a loop of another without a sync error
View as plain text  
From 10000 feet, what you are attempting to do looks like it would be
very easily accomplished with a join, leaving you with 1 result set to
process.  I realize that isn't the question, but it might be a
solution.

 - michael dykman

On Wed, Jan 19, 2011 at 9:54 PM, Delan Azabani <delan@stripped> wrote:
> Hi all,
>
> I'm using MySQL with C in a CGI application. I hope this is the right
> list to ask for help.
>
> If I have this simplified code:
>
> MYSQL_RES *res;
> MYSQL_ROW row;
> mysql_query(mysql, "some select query");
> res = mysql_use_result(mysql);
> while (row = mysql_fetch_row(res)) {
>    MYSQL_RES *res2;
>    MYSQL_ROW row2;
>    mysql_query(mysql, "some other select query using an id from the
> first");
>    res2 = mysql_use_result(mysql);
>    /* ... */
>    mysql_free_result(res2);
> }
> mysql_free_result(res);
>
> Whenever I run the second query, inside the loop, I get the nasty
> 'commands out of sync' error. How can I run a select query while in a
> loop fetching rows from another select query? Or, do I have to fetch all
> the rows completely first and store them in memory (which wouldn't be
> very 'nice' to do)?
>
> If someone could help me with this problem, it would be greatly appreciated.
>
> --
> Thanks and best regards,
> Delan Azabani
> http://azabani.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
running a mysql query inside a loop of another without a sync errorDelan Azabani20 Jan
  • Re: running a mysql query inside a loop of another without a syncerrorMySQL)20 Jan
  • Re: running a mysql query inside a loop of another without a sync errorMichael Dykman20 Jan