Using get_team_array() in a custom query

[chrislynch8]

Hi,

I want to use the returned array from get_tem_array() in a custom query. In this test the array contain 33 records, that I want to use in the where clause of my query

Select * from table where team_name IN (my returned array)

How do I do this?

Rgds
Chris

[kuske]

Something like this:

 $team_name_list = '';
$team_id_list = '';
foreach(get_team_array() as $id=>$name){
   if ($team_id_list == ''){
      $team_id_list = "'" . $id . "'";
      $team_name_list = "'" . $name . "'";
   } else {
      $team_id_list .= ",'" . $id . "'";  
      $team_name_list = .",'" . $name . "'";
   }
} 
  

and then

$qry="Select * from table where team_id IN (".$team_id_list.")"

or

$qry="Select * from table where team_name IN (".$team_name_list.")"

???

[chrislynch8]

That is perfect, thank you very much

Rgds
Chris