Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Search Forums
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Showing results 1 to 15 of 15
Search took 0.00 seconds.
Search: Posts Made By: Eric
Forum: Tips, Tricks & Tutorials September 21st, 2012, 09:44 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi You can do this in your view: <?php echo...

Hi

You can do this in your view:

<?php echo dfr_get_brands('994433,994434,994435,994436'); ?>

And this in your function:

if ($cat) { $cat_query = "WHERE p2c.cat_id IN (".$cat.") "; }
Forum: Tips, Tricks & Tutorials September 20th, 2012, 04:54 PM
Replies: 32
Views: 8,215
Posted By Eric
Are you passing 1 or more than 1 category IDs...

Are you passing 1 or more than 1 category IDs into the dfr_get_brands() function?
Forum: Tips, Tricks & Tutorials September 20th, 2012, 09:04 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi You need to use MySQL's IN(). WHERE...

Hi

You need to use MySQL's IN().

WHERE p2c.cat_id IN(994434,994435,994436)

Eric
Forum: Tips, Tricks & Tutorials September 15th, 2012, 05:11 PM
Replies: 32
Views: 8,215
Posted By Eric
Try this function: function...

Try this function: function dfr_get_brands($cat=false) {
global $wpdb;
if ($cat) { $cat_query = "WHERE p2c.cat_id = ".$cat." "; }
$brands = $wpdb->get_results("
SELECT brand, p2c.cat_id
FROM...
Forum: Tips, Tricks & Tutorials September 15th, 2012, 04:21 PM
Replies: 32
Views: 8,215
Posted By Eric
Hi This means the products appearing in this...

Hi

This means the products appearing in this category are already in another category and the query will need to use a JOIN on the p2c table.

Eric
Forum: Tips, Tricks & Tutorials September 15th, 2012, 11:59 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi Can you change the HTML to this (below), load...

Hi

Can you change the HTML to this (below), load the page and copy any of the <pre>formatted text and paste it here?

<pre><?php print_r($category); ?></pre>

<form method="get">

<!-- Brand...
Forum: Tips, Tricks & Tutorials September 15th, 2012, 11:25 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi Try replacing this:...

Hi

Try replacing this: [DFR:widget/category-specific-brand-drop-down]

With this: <form method="get">

<!-- Brand drop down select menu -->
<select name="brand">
<?php echo...
Forum: Tips, Tricks & Tutorials September 15th, 2012, 11:08 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi It seems you are referencing the wrong widget...

Hi

It seems you are referencing the wrong widget from your Category Page view. You are referencing: [DFR:widget/drop-down-filter]. That view is empty.

You should be referencing "Category specific...
Forum: Tips, Tricks & Tutorials September 15th, 2012, 08:52 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi I still see the "Don't cache this view"...

Hi

I still see the "Don't cache this view" unchecked here: http://factory3.datafeedr.com/feeder/view?view=224338

Eric
Forum: Tips, Tricks & Tutorials September 15th, 2012, 08:19 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi You should disable caching the View where...

Hi

You should disable caching the View where your <select> form is. Go to the View menu > View Properties and check the "don't cache this view" checkbox.

Also, make sure you don't have any other...
Forum: Tips, Tricks & Tutorials September 15th, 2012, 08:02 AM
Replies: 32
Views: 8,215
Posted By Eric
Did you turn off caching for that view?

Did you turn off caching for that view?
Forum: Tips, Tricks & Tutorials September 15th, 2012, 07:36 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi Your code works for me. I do see you have an...

Hi

Your code works for me. I do see you have an extra closing </select> tag.

Make sure you don't cache your view.

Eric
Forum: Tips, Tricks & Tutorials August 28th, 2012, 03:51 PM
Replies: 32
Views: 8,215
Posted By Eric
Hi It's due to the merchant's feed. You can...

Hi

It's due to the merchant's feed. You can change the product's brand in the Factory but if you have lots of products, that could take some time.

Eric
Forum: Tips, Tricks & Tutorials July 3rd, 2012, 11:04 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi It will get you all brands so you'll need to...

Hi

It will get you all brands so you'll need to modify the query like you've done above.

Eric
Forum: Tips, Tricks & Tutorials July 3rd, 2012, 09:43 AM
Replies: 32
Views: 8,215
Posted By Eric
Hi James, Welcome to the forums! I've posted...

Hi James,

Welcome to the forums!

I've posted how to do dropdown menus for merchants and brands here: http://www.datafeedr.com/forums/showthread.php?t=6778

Eric
Showing results 1 to 15 of 15

 
Forum Jump

All times are GMT -5. The time now is 09:39 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.