WordPress database error: [Incorrect file format 'wp_comments']
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (34,33,32,31,30,29,28,27,26,25) GROUP BY ID

2005 August | TicTap Blog

Archive for August, 2005

« Previous Entries

Amazon Sales Rank Tracker

Friday, August 26th, 2005

We’ve just included a sales rank tracker for every product.

Do your normal or long tail search and you should see an option to view the sales rank for every product.

We’ll show you the sales rank for the last 30 times it was tracked.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 34 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '34' AND comment_approved = '1'

No Comments »

Amazon’s Random Long Tail Items

Friday, August 26th, 2005

Thanks to Crispy who wrote in and said he wished for long tail items in our random product search. We’ve got that working now.

Test drive it here.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 33 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '33' AND comment_approved = '1'

No Comments »

Searching Amazon.com’s Long Tail

Tuesday, August 23rd, 2005

We have all heard of the long tail right?

I was captivated by the concept and wondered what hidden gems might be available if I could search the long tail.

The problem was, How do I search the long tail?

It wasn’t clear to me at all how I could do that at Amazon.com, and their web API […]

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 32 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '32' AND comment_approved = '1'

No Comments »

Improved Recommendations

Sunday, August 21st, 2005

We’ve tweaked our product recommendations algorithm over the last week, and have given it prominent placement now.

The nice thing about our recommendations is that it contains more (hopefully relevant) products than the usual 5 that Amazon.com returns, so you have more choices.

Let us know how we can make it better for you.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 31 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '31' AND comment_approved = '1'

No Comments »

Super Search Tool

Tuesday, August 16th, 2005

During my free time, I created another Konfabulator widget called Super Search.

It’s a handy tool for you to search A9.com, Amazon.com, Answers.com, Ask.com, Bible Gateway, Bugmenot.com, Factmonster, Feedster, Flickr, Freshmeat, Google, Hotjobs, IMDB, Monster.com, MSN Encarta, MSN Web, SourceForge, Technorati, Urban Dictionary, Wikipedia, Yahoo! … well, you get the idea!

Check out the screenshot and download […]

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 30 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '30' AND comment_approved = '1'

No Comments »

Product Recommendations by SMS

Saturday, August 13th, 2005

Many of you who have used the TicTap SMS service to search for low prices and customer ratings have asked for product recommendations.

Now you have it!

To get recommendations for any ISBN or UPC, text r ISBN_OR_UPC_CODE to 763-807-3927 .

For example, to get recommendations for products similar to Harry Potter and the Half-Blood Prince (Book […]

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 29 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '29' AND comment_approved = '1'

No Comments »

Yahoo! Song and Podcast Search

Monday, August 8th, 2005

Our TicTap widget now includes song and podcast search abilities. It uses the audio API from Yahoo.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 28 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '28' AND comment_approved = '1'

No Comments »

TicTap Widget Accepted at Konfabulator

Sunday, August 7th, 2005

It’s nice to know the good folks at Konfabulator have accepted our submission for the widget.

Download here.

You can also get it directly from TicTap.

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 27 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '27' AND comment_approved = '1'

No Comments »

TicTap Widget Beta

Thursday, August 4th, 2005

The widget is officially in Beta. We thank all the people who have given us feedback.

From now on, you can grab the TicTap widget here. We’ve even posted a screenshot of what it looks like.

Don’t stop your feedback ok?

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 26 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '26' AND comment_approved = '1'

No Comments »

Find New Releases at TicTap.com

Wednesday, August 3rd, 2005

We’ve launched a new category for newly released products for TicTap.com.

Happy shopping!

Posted in General (talk) |

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 25 AND comment_approved = '1';

WordPress database error: [Incorrect file format 'wp_comments']
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '25' AND comment_approved = '1'

No Comments »

« Previous Entries