Query Issue In Server

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..

The error is

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

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

Regards,
Suganya

 

give it a try like this

$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);

if wont work,
try and add extra quotas everywhere you think they must be, because that's the issue from error