SELECT Error

[nagrap2]

Hi,

I am modifying a query in one my functions listed under the smarty folder by joining two tables.

The SQL code I am using is as follows:

$sSQL="SELECT id,title,price,dateadded,firstname,lastname FROM ".PREFIX."listings, u.".PREFIX."users WHERE u.id = owner AND display = 'Y' AND expiration > NOW() ORDER BY dateadded desc LIMIT ".$number;

I am getting following error on my php page:

Notice: Query failed: SELECT command denied to user 'xxxxxxxxxxx'@xxxxxxxxxxxxxx' for table 'class_users' SQL: SELECT id,title,price,dateadded,firstname,lastname FROM class_listings, u.class_users WHERE u.id = owner AND display = 'Y' AND expiration > NOW() ORDER BY dateadded desc LIMIT 8 in /home/content/t/u/t/tutorheaven/html/includes/classes/database/mysql.php on line 134

I have replaced the username and ip address with "xxxxxxxxxxxxxx" above.

Can someone let me know why I'm getting this error and how can I resolve?

Thanks in advance...

[Lhotch]

Was there an existing query in the file and function you are editing?

Also, it helps us if you can be a bit more specific about the file and/or function you are editing.

[nagrap2]

Hi,

I originally made a copy of "smarty_function_feature_listings_horizontal" and modified the SQL so that it displays new listings and named the function "smarty_function_new_listings_horizontal". Location: homepage\includes\classes\smarty\plugins

The function was working fine with the original SQL I had modified: $sSQL="SELECT id,title,price,dateadded FROM ".PREFIX."listings WHERE display = 'Y' AND expiration > NOW() ORDER BY dateadded desc LIMIT ".$number;

I then wanted to add the First Name and Last Name of the owner of each listing and so changed the SQL to the following, and this is now giving me the error I mentioned:

$sSQL="SELECT id,title,price,dateadded,firstname,lastname FROM ".PREFIX."listings, u.".PREFIX."users WHERE u.id = owner AND display = 'Y' AND expiration > NOW() ORDER BY dateadded desc LIMIT ".$number;

[Eric Barnes]

I think it should be:
FROM ".PREFIX."listings LEFT JOIN ".PREFIX."users AS u