[SOLVED] UNION statement

[Bricktop]

Hi all,

 

Could someone please tell me what's wrong with this UNION statement.  I'm guessing the syntax is wrong somewhere in my PHP code but it's the first time I've used the UNION operator and I'm a bit stuck.  Anyway, here it is:

 

$sql = mysql_query("SELECT DISTINCT staffcode FROM users") UNION ("SELECT firstname, surname, profile, email, telephone, FROM users ORDER BY surname ASC");

 

Thanks in advance.

[Bricktop]

Hi all,

 

I now have the correct PHP syntax but the result is blank, I don't seem to be returning any data.  Here is the new code:

 

$sql = mysql_query("(SELECT DISTINCT staffcode FROM users) UNION (SELECT firstname, surname, profile, email, telephone FROM users ORDER BY surname ASC)");

[Bricktop]

Sorry, I've worked out that I can't have a different number of coulmns when using UNION statements. 

 

Thanks anyway.

[fenway]

That's true, but you can't work around it if necessary.