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_query(dbfd, ls_sql, strlen(ls_sql)); num = mysql_affected_rows(dbfd); When it execute the second check sql, it report "out of sync error", What wrong with it? Thanks in advance. --------------------------------------------------------------------- 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