Help to get out data from Array

[fabiuz]

Hi,

stupid question may be...but I am becoming crazy because I cannot find a working way :-(

I am in this situation:

I have a mysql table, I am running some query on it.

So I have these arrays:

$res1 = MySQL_query($sql1);
$res2 = MySQL_query($sql2);
$res3 = MySQL_query($sql3);
$res4 = MySQL_query($sql4);

I cannot use mysql_fetch_array to get out data because I want to merge all these arrays to eliminate douplicate values.
So I merge them :

$array_merge = array_unique($res1,$res2,$res3,$res4);

ok, and now ?

How can I get out the data ?

Thank you for any help about !

Fabi

[jowatkins]

would this help at all

while(list($key,$value)=each($array_merge))
{
  echo "$key, $value";
}

[fabiuz]

Ok, thank you, now I get something like that:

0, Resource id #101, Resource id #112, Resource id #123, Resource id #13

How to get values in fields ?

Fabi

[ozzie]

can u not do?:

while($data=mysql_fetch_array($res1)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res2)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res3)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res4)){
  $newarray[]=$data;
}
// Eliminate duplicates
$newarray = array_unique($newarray);
for($i=0;$i<count($newarray);$i++)
{
  while(list($key,$value)=each($newarray[$i]))
  {
    echo "$key, $value\n";
  }
}

[fabiuz]

Yes!

Now I can get out results but I am very confused :-(

I get something like that for a test query:

key: 0, value: 812
key: idautore, value: 812
key: 1, value: VASCO ROSSI
key: nome_gruppo, value: VASCO ROSSI
key: 2, value: 12.887968268516
key: score, value: 12.887968268516
key: 0, value: 50
key: idautore, value: 50
key: 1, value: VALERIA ROSSI
key: nome_gruppo, value: VALERIA ROSSI
key: 2, value: 6.104728680783
key: score, value: 6.104728680783
key: 0, value: 812
key: idautore, value: 812
key: 1, value: VASCO ROSSI
key: nome_gruppo, value: VASCO ROSSI
key: 0, value: 812
key: idautore, value: 812
key: 1, value: VASCO ROSSI
key: nome_gruppo, value: VASCO ROSSI

If I apply array_unique only the first result is displayed and this is not good.

But I cannot understand the array by itself...which is his content ? Why I get two times the filed "idautore" ?

The fields in query are:

idautore and nome_gruppo, why also the record with 0 and 1 key ?

Why unique doesn't work ?

Thank you very much !!

FAbi

[ozzie]

To see exactly what is in each array do:

while($data=mysql_fetch_array($res1)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res2)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res3)){
  $newarray[]=$data;
}
while($data=mysql_fetch_array($res4)){
  $newarray[]=$data;
}
echo "Before:\n";
print_r($newarray);

// Eliminate duplicates
$newarray = array_unique($newarray);

echo "After:\n";
print_r($newarray);

[fabiuz]

I'll try, thank you again !

Only one thing: my array is multidimensional array son array_unique doesn't work... how can I do ?

Fabi

[fabiuz]

This is what I get:

Array (

[0] => Array( 

		[0] => 812 [idautore] => 812 
		[1] => VASCO ROSSI [nome_gruppo] => VASCO ROSSI 
		[2] => 12.887968268516 [score] => 12.887968268516 
) 

[1] => Array( 
		[0] => 50 [idautore] => 50 
		[1] => VALERIA ROSSI [nome_gruppo] => VALERIA ROSSI 
		[2] => 6.104728680783 [score] => 6.104728680783 
) 

[2] => Array ( 
		[0] => 812 [idautore] => 812 
		[1] => VASCO ROSSI [nome_gruppo] => VASCO ROSSI 
) 

[3] => Array ( 
		[0] => 812 [idautore] => 812 
		[1] => VASCO ROSSI [nome_gruppo] => VASCO ROSSI 
)

)

I need to remove records where "idautore" is the same...so in this case I would like to get only 2 records:

VASCO ROSSI
VALERIA ROSSI

and to prim them out...

Could you help ?

Fabi

[ozzie]

Could u post the table struture of your database please including the fields in each table

[fabiuz]

The table is easy:

idautore PRIMARY KEY AUTOINCREMENT UNIQUE
nome_gruppo VARCHAR(100)

I am running a FULLTEXT SEARCH on MYSQL table this is the reason why in the first query result I get also a fild called "score".

I have understtod something more now but I am still unable to remove duplicate keys... I am working on something similar to :

for($i=0;$i<$contenuto_array;$i++) {

for ($ii=0;$ii<$contenuto_array;$ii++) {

	if ($newarray[$i][0] == $newarray[$ii+1][0]) {
		unset($newarray[$ii+1][0]);
	}
}

}

but it is not ok...

Array outpur with <PRE> is:

Array
(
[0] => Array
(
[0] => 812
[idautore] => 812
[1] => VASCO ROSSI
[nome_gruppo] => VASCO ROSSI
[2] => 12.887968268516
[score] => 12.887968268516
)

[1] => Array
    (
        [0] => 50
        [idautore] => 50
        [1] => VALERIA ROSSI
        [nome_gruppo] => VALERIA ROSSI
        [2] => 6.104728680783
        [score] => 6.104728680783
    )

[2] => Array
    (
        [0] => 812
        [idautore] => 812
        [1] => VASCO ROSSI
        [nome_gruppo] => VASCO ROSSI
    )

[3] => Array
    (
        [0] => 812
        [idautore] => 812
        [1] => VASCO ROSSI
        [nome_gruppo] => VASCO ROSSI
    )

)

[ozzie]

Can u not just do 1 query:

SELECT DISTINCT idautore, nome_gruppo FROM table

Tell me if I'm missing something (don't userstand the FULLTEXT SEARCH on MYSQL table)

[fabiuz]

thanks again,

I cannot do onyl one query because I have build a little search engine, FULL TEXT STRING works very well but not perfectly and also it doesn't take care of words less then 4 chars.

So I need to make other queries to get more results also if typed word is less then 4 chars. I remember now that FTS also searches only for full words so if you type only some chars of a word it cannot find anything...

These are the reasons for more then one query.

I am really near to the solutions, the last stop is find how to remove double records from the array... have you got any idea about ?

Thanks

Fabi