Re: why doesn't this work? (C code) - fixed (I hope)

[Peter Faulks]

I wrote:

>This USED to work, then all of a sudden for no apparent reason it has suddenly 
>decided not to: 

Notwithstanding it used to work, it would _appear_ that calling mysql_free_result() 
willy-nilly was the cause:

mysql_query(&mysql, theSql);
res1 = mysql_store_result(&mysql); 
if(res1)
{
  while((row1 = mysql_fetch_row(res1)))
  {
    printf(theHtml1, row1[4]);
    if(*row1[2] == 'l')
    {
      sprintf(theSql, 
      "SELECT so_val, so_text FROM slct_optns WHERE otype_id = %s"
      " AND so_val > 0 ORDER BY so_val", row1[1]);
      mysql_query(&mysql, theSql);
      res2 = mysql_store_result(&mysql);
      if(res2)
      {
        printf("<select name=\"%s\">", row1[5]);
        while((row2 = mysql_fetch_row(res2)))
          printf("\n<option value=\"%s\">%s</option>", row2[0], row2[1]);
        printf("</select>");
        mysql_free_result(res2);
      }
    }
    else if(*row1[2] == 'e')
    {
      printf("&nbsp;%s&nbsp;<input type=\"text\" name=\"%s\" maxlength=\"%s\">", 
row1[3], row1[5], row1[8]); 
    }
    printf("</td>\n</tr>");
  }
  mysql_free_result(res1);
}

seems to fix the problem..

Regards





---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php