saeed

char query[255];sprintf(query, "SELECT AccountNumber FROM Accounts WHERE AccountNumber='%d'", accountNumber);openConnection(call);MYSQL* mysql = call->mysql;mysql_real_query(mysql, query, strlen(query));MYSQL_RES * res = mysql_store_result(mysql);MYSQL_ROW row = mysql_fetch_row(res);int retVal = row ? accountNumber : 0;mysql_free_result(res);mysql_close(mysql);return retVal;