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;