Query does not return data

[carlwhat]

@mc12345678, doing what you will suggest will not solve @johnnyh's issue.

as far as i can tell, the problem is with the $language_id.

#1, it does not look like you have the DEFAULT_LANGUAGE set in the admin. that said, it looks to be a hidden configuration.
#2, it would still not work, as they are using the default language code as opposed to the languages_id.

the languages_id looks to get set in includes/init_includes/init_languages.php and it looks to be a SESSION variable.

so first, revert the code to the original. and then i would change the code as such:

//from
if($_GET['language_id']=='')
{
$lang=mysqli_fetch_assoc(mysqli_query("select languages_id from ".DB_PREFIX."languages where code in (select configuration_value from ".DB_PREFIX."configuration where configuration_key='DEFAULT_LANGUAGE')"));
$language_id=$lang['languages_id'];
}
else
$language_id=$_GET['language_id'];

//to:
if($_GET['language_id']=='')
{
$language_id=$_SESSION['language_id'];
}
else
$language_id=$_GET['language_id']; 

in addition, i think once you have the script in its original form (or the new revised form), the following link could work:

http://artos.dk/zencart/storeya_feed.php?language_id=1

good luck! let us know how it goes!

1 last thing, there does look to be some extra spaces in the original mysql query:

select ".DB_PREFIX."products.products_id,products_price,products_price_sorter,products_ image,products_name,products_description,products_url from ".DB_PREFIX."products,".DB_PREFIX."products_description where ".DB_PREFIX."products.products_status='1' and ".DB_PREFIX."products.products_id=".DB_PREFIX."products_description.products _id and ".DB_PREFIX."products_description.language_id='".$language_id."' order by ".DB_PREFIX."products.products_id

specifically here:

products_ image

and

products_description.products _id

i would remove those 2 extra spaces.