TEmp design on searching keywords from other tables

String strTemp,
Array aryKeywordCode[]

1. select K from temp_db where (search criteria)
2. return the results[the keywords] and APPEND in a string
3.
i=0
j=0
iLenStrTemp = Length(strTemp) // count the length of the strTemp
Do
 read charter[i] from strTemp[i]
 if the charter != ','
   APPEND charter[i] into strTemp
   i++
 else  // i.e. arrive the charter ','
   save strTemp into the aryKeywordCode[j]
   strTemp = ''  //initialize strTemp
   j++
 end if
  iLenStrTemp--
While (iLenStrTemp == 0)

4. dispatch the string by determinents: ','
4.1 insert into a temp table
iLenAryKeywordCode = Length(aryKeywordCode)
i = 0
Do
  // TABLE NOT YET CREATED!!
  // select keywords from table_keywords where tbl_keyword_code = '_aryKeywordCode[i]_'
  aryKeyword[i] =  _QUERY_RESULT // should be one and only one return
  i++
  aryKeywordCode--
While (aryKeywordCode == 0)

// 4.1 Search the keyword base on the ketword code:
// iLenAryKeywordCode = Length(aryKeywordCode)
// i = 0
// Do
//   // TABLE NOT YET CREATED!!
//   // select keywords from table_keywords where tbl_keyword_code = '_aryKeywordCode[i]_'
//   aryKeyword[i] =  _QUERY_RESULT // should be one and only one return
//   i++
//   aryKeywordCode--
// While (aryKeywordCode == 0)
//
// 4.2 After retrieving all the keyword by searching, store the keyword into a