here's my php code, but its not doing anything. Is the syntax right?
(especially on the select statement)

$sql="Select * From COMPANY As C Inner Join ACTIVITY AS A On A.C_NUMBER = C.C_NUMBER
Where C.A_DATE = '$date'";
$result = mysql_query($sql);
//$numofrows = mysql_num_rows($result);
echo $result;
THANKS