Commands out of sync Error

2002-08-11 Thread Jocelyn Fournier
Hi, I'm sometimes experiencing in my application the "commands out of sync; You can't run this command now" error. According to the MySQL manuel, it means : This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result().

Commands out of sync error when check tables

2001-11-13 Thread sj
hi, I execute two check command using C, it report "Command out of sync error". the original statement is as below: sprintf(ls_sql, "check table aa"); mysql_real_query(dbfd, ls_sql, strlen(ls_sql)); num = mysql_affected_rows(dbfd); sprintf(ls_sql, "check table bb"); mysql_real_qu