Dynamic table names

[ougk]

Hi all

i want to create some arrays but with the name of some variables.. (hmm let me refrase that;p)

I take some unique ids from a query, and after some processing i put them in an array named Sites. I want when i put the sites in the array called "Sites" to create a new array for every unique id, with the name of the id... how should i do that?

thx

ps. the new arrays will have a dynamic content so the thing i would like to do has a meaning;-))

[coreyp_1]

you could either use variable variables or an associative array of arrays.

If I am misunderstanding your question, could you please give us an example or two of what you are trying to do?

[thegoldenchild]

I don't exactly know what u mean..but maby u want to do this..

extract($Sites)

After that the Array will be extracted and all table fields wil be like: $username $password etc.

[ougk]

Hmm...

I take from a query ids like

ougk12
ougk34
ougk45 and so on (i dont know the exact name of the ids before i run the query).

After some process, (to avoid dublicates) i put them in an an array using the following...
$i=0;

if($found1==FALSE){  

									$Sites[$i]=$Row[6]; //Row[6] has the id i want
									$i++;

//i want here to create an array named $Sites[$i]

if i use the $$Row[6]=array ( );

i haven't got the proper outcome...
and then how should i access the table named $Sites[$i] or $Row[6] here...

[kakki]

maybe this:

// DISTINCT to avoid duplicate ids
$q=mysql_query( "SELECT DISTINCT id FROM tableName" );
while ( $line = mysql_fetch_array( $q ) )
{
   $sites[] = $line[ 0 ];
} 

or

$sites=array();
$q=mysql_query( "SELECT id FROM tableName" );
while ( $line = mysql_fetch_array( $q ) )
{
   $sites[ $line[ 0 ] ] ++;
} 
// to get the content of $sites
foreach ( $sites as $item => $count )
{
   // $item   -> site_id
   // $count -> how many sites with this id
}