Help - Manufacturer in Datafeed.php needed

Store Builder Questions
1

Hi,

I have an automated datafeed.php and I have to extract also the Manufacturer information form the database.



The info I need is located in the variant_id field in product_features_values table having feature_id = 5 (this is the manufacturer id).

I updated the .php file with:

<br />
	$prod_producator = db_query("SELECT :product_features_values.variant_id<br />
    FROM ?:product_features_values<br />
    WHERE ?:product_features_values.feature_id = '5'");
```<br />
...<br />
```php
print<br />
$prod_producator..
```<br />
<br />
..<br />
but when I view the .php file it shows:<br />
<br />
...[B]Resource id #122[/B]...<br />
<br />
can anybody tell me what I have done wrong, I am not good with .php<br />
<br />
Thanks,<br />
Daniel
2

Nobody has any idea?

3

Replace db_query function with db_get_field.

4

Thanks a lot zeke, after your suggestion I managed to make it work