2 Selects in one array...

[Anon]

If towho is queue i get the stuff from the queue_table into $mailadresses
If towho is account i get it from account_table
BUT else i want to get the stuff from $queue_table and $account_table into $mailadresses. How can i do this? THX 🙂

if ($towho == "queue"){$mailadresses = mysql_query("SELECT email FROM $queue_table");}
elseif ($towho == "accounts") {$mailadresses = mysql_query("SELECT email FROM $account_table");}
else {$mailadresses = mysql_query("SELECT email FROM $queue_table, $account_table");}

[tomhath]

You need at least mysql 4.0 to use UNION:

SELECT email FROM $queue_table
UNION
SELECT email FROM $account_table

[Anon]

ah lol thx mate!