UNION command

[TobesC]

i know this is mysql, but can anyone find anything wrong with this query? the UNION command is the problem because i've tried all the SELECTS separately.

 

query is:

 

$result=mysql_query("SELECT * FROM `math` UNION SELECT * FROM `science` ORDER BY `timestamp` DESC");

 

mysql_fetch_array gives an invalid mysql resource.

 

any help is greatly appreciated - this is driving me nuts. . .

 

thanks.

[R0bb0b]

first off, which table is your "timestamp" in, science?

[Barand]

And do math and science tables have the same number of columns of the same respective types

[DarkWater]

Also, can you get the error message from the mysql query so we actually know what the problem is?  It should look something like:

 

$result = mysql_query($query) or die(mysql_error());