Re: running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Michael Dykman
>From 1 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 wrote: > Hi all,

Re: running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Shawn Green (MySQL)
Hello Delan, On 1/19/2011 21:54, Delan Azabani 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); whil

running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Delan Azabani
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;