Query Issue In Server

[sugan]

Hi,I used the below query in my localhost, where it gave me everything correctly without any issues, but when i see it after uploading my files in my site, it gives me an error..

$s = mysql_query("select c.name,b.short,a.date, a.link_lid, a.dir_id, a.status, c.linkadd from link as b left join dir as c, submit as a on a.link_lid=b.lid and a.dir_id=c.id where c.type='$dir' && b.site='$site' order by stat desc", $link);while ($row = mysql_fetch_array($s, MYSQL_BOTH)) {

The error is

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/..... on line 115

If i run the above query in my phpmyadmin also, i am getting error as:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' submit as a on a.link_lid=b.lid and a.dir_id=c.id

Everything works fine in my localhost. How to resolve this issue?Regards,Suganya