Querying two tables

[Elhombrebala]

Do you know why I get this error making a query in 2 tables?

THE QUERY (LINE 22 as error saids):

$result = mysql_query("SELECT * FROM Precios, Disponibilidad WHERE (Ref='$Ref')", $link);
while($row = mysql_fetch_array($result)) {
echo $row["ene2"];
}

THE ERROR:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /chs/p1/costa4seasons.com/home/html/changes.html on line 22

[njm]

Your PHP syntax is correct, the error is occurring because the MySQL query is invalid. Try looking at what mysql_error() says.

hth njm

[Elhombrebala]

What mysql saids is this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /chs/p1/costa4seasons.com/home/html/changes.html on line 22

and the line 22 is what I have copied before.
😕