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(" %s <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
