gettting results.. then erm joining them...

Grofit

hey there again,

is it possible to add lots of results together... let me give an example so it makes more sense.. im talking about the returned objects/arrays (i prefer to use objects)

$MySQLObject <==== pre initilized

$MySQLQuery = "Select Name, Address FROM ukcustomers WHERE = 'Purchased>100' LIMIT 0, 60";

$MySQLResult = mysql_query($MySQLQuery, $MySQLObject) or die(mysql_error());

$UK_Customer_List = mysql_fetch_object($MySQLResult);

ok now from that i have the customer list from the uk where they have purchased over 100.... so now if we want to get US ones..


$MySQLObject <==== pre initilized

$MySQLQuery = "Select Name, Address FROM uscustomers WHERE = 'Purchased>100' LIMIT 0, 60";

$MySQLResult = mysql_query($MySQLQuery, $MySQLObject) or die(mysql_error());

$US_Customer_List = mysql_fetch_object($MySQLResult);

ok so now we have $UK_Customer_List and $US_Customer_List, both have EXACTLY the same tables, just different contents.. now is there any way to merge the UK data retrieved with the US one in one object?

so i could have 1 variable called $Complete_Customer_List thats full of both US/UK data?

hope that makes sense....

devinemke

arrays would be easier:

function get_customers($arg)
{
	$result = mysql_query('SELECT Name, Address FROM ' . $arg . 'customers WHERE Purchased > 100 LIMIT 0, 60');
	while ($row = mysql_fetch_array($result))
	{
		$row['country'] = $arg;
		$array[] = $row;
	}

return $array;
}

$uk = get_customers('uk');
$us = get_customers('us');

$Complete_Customer_List = array_merge($uk, $us);

note that each index has a key called "country" to tell US and UK customers apart.

LordShryku

Or union the queries and do it all as one query.

Roger_Ramjet

Beat me to it LordShryku. Yes, Grofit, use the union query and save your server lots of processing.

LordShryku

My speed-typing monkey style kung foo will defeat your hunt-n-peck dragon style roger san :p

Roger_Ramjet

More like my dyxlexic-pig's trotters style, oh esteamed master.

mourisj

... or merge both (or more) customer-tables into one and flag the items with a country-code

JJ Mouris

Grofit

k and how do you go about union querys?

k thx.. so i have to use arrays not objects

(this is just an example btw, my actual DB is nothing to do with customers etc..lol just wanted to simplify things)

mourisj

select col1, col2 ...
from table1
where (...)
UNION
select col1, col2 ...
from table2
where (...)

Number of columns AND datatypes for each column MUST MATCH

JJ Mouris

Grofit

Brilliant! thanks 🙂

Roger_Ramjet

Sorry, wrong thread.