new count;format(query,sizeof(query),"SELECT * FROM tablename'");mysql_query(query);mysql_store_result();if(mysql_affected_rows()){ count ++;}printf("count = %d",count);