creating one array from two table columns

[happyme]

I have two tables, each of which have a column called approved.

I want to create an array filled with:

values of id from table1 where approved = 2
and
values of reference from table 2 where approved =2

this is my failed attempt:

I realise I need to learn more about using arrays, any links appreciated.

$result1 = mysql_query("SELECT id FROM $tablename1 WHERE approved = 2",$db);
$result2 = mysql_query("SELECT reference FROM $tablename2 WHERE approved = 2",$db);

while ($myrow = array_unique(array_merge( mysql_fetch_array($result1), mysql_fetch_array($result2)) 

{//display contents of array here}
PHP]

[sgoku01]

Is this okey too, or do you really need 1 array with all the info?

$result1 = mysql_query("SELECT id FROM $tablename1 WHERE approved = 2",$db); 
$result2 = mysql_query("SELECT reference FROM $tablename2 WHERE approved = 2",$db); 

while(($row = mysql_fetch_array($result1)) and ($row2 = mysql_fetch_array($result2)))
{
echo $row['id'] . "<br>" . $row2['reference'];
}

[happyme]

I need one array as I need to get a set of unique values.

I could do it by adding one set of values to the array then the other set and then create a unique array from that.

Julia

[nnichols]

This will create an array of all the values from the two result sets -

$result1 = mysql_query("SELECT id FROM $tablename1 WHERE approved = 2",$db); 
$result2 = mysql_query("SELECT reference FROM $tablename2 WHERE approved = 2",$db);

while ($row = mysql_fetch_row($result1)) {
$all_array[] = $row[0];
}

while ($row = mysql_fetch_row($result2)) {
$all_array[] = $row[0];
}

You then need to do some sorting and evaluation of the array to get unique results

// this gets rid of duplicate values
$unique_array = array_unique($all_array);

// this sorts the array by values (not keys)
$unique_array = sort($unique_array);

Hope this helps 😉

[happyme]

this all looked very promising, but I got a whole load of errors:

while ($row = mysql_fetch_row($result1)) {$all_array[] = $row[0];}

gives:

Warning: Supplied argument is not a valid MySQL result resource

$unique_array = array_unique($all_array);

gives:

Warning: Wrong datatype in array_unique() call

and

$unique_array = sort($unique_array);

gives:

Wrong datatype in sort() call

[nnichols]

The first error results in the other errors. Because no result set is returned no array is created. This means that when passed to array_unique() it is not an array.

Please post the code you are using (in full) and I will have a look.