retriving data from more than 1 table ERROR

[lands]

Im trying to show info from more than 1 table and order them by the date they are submitted, but im getting this error

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /LINK on line 19, line 19 by the way is > $RESULT=.......

any ideas???
<?php
$con = mysql_connect('DETAILS');
if (!$con)
{die('Could not connect: ' . mysql_error());}
mysql_select_db('DETAILS', $con);

$result = mysql_query'(SELECT FROM table1) UNION (SELECT FROM table2) ORDER BY date DESC)';

while($row = mysql_fetch_array($result))
{

echo

"INFO HERE"; } ?>

[dagon]

look at the number of ( 2 vs ) 3

[Derokorian]

$result = mysql_query'(SELECT * FROM table1) UNION (SELECT * FROM table2) ORDER BY date DESC)';

Should be:

$result = mysql_query('(SELECT * FROM table1) UNION (SELECT * FROM table2) ORDER BY date DESC');