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 (15,14,13,12,11,10,9,8) GROUP BY ID

2005 May | TicTap Blog

Archive for May, 2005

Lookup library books

Thursday, May 26th, 2005

From today, you can lookup books you find at TicTap at your nearest library.

All books returned in our search results will have a Library lookup feature. If you have not already selected a libary of your choice, do so. Once you have done that, a search for that book at your library is just a […]

Posted in General (talk) |

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

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

No Comments »

Movie reviews from Google!

Wednesday, May 25th, 2005

Did you know that Google offers movie showtimes and reviews?

We just learnt it and have added this feature to TicTap.

From now on, wherever reviews from Amazon.com are available for DVD and VHS tapes, you will also see a “Google might have reviews too” link. Click on it, and we’ll send you to […]

Posted in General (talk) |

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

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

No Comments »

Search by UPC

Monday, May 16th, 2005

TicTap now allows you to search by Universal Product Code (UPC).

We have an explanation of what a UPC is here, and how to identify it.

For an example search by UPC, try this:
http://www.tictap.com/s/718908519066.

Posted in General (talk) |

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

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

No Comments »

Search history archive

Thursday, May 12th, 2005

Once again, we were reminded by our users that we have done a poor job of communicating certain features of TicTap.

A user wrote in to say that our search history is too short - only the last 5 searches are shown.. pathetic!

Actually, if you are registered and signed-in, you can see up to 10 immediately. […]

Posted in General (talk) |

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

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

No Comments »

Labels and shopping lists

Thursday, May 12th, 2005

One feature of TicTapWeb that I use very often is the labels feature.

Unfortunately, many users do not use it and I was wonderig why.. turned out we did a really hopeless job of telling people about it. So in this post, I will try to explan what labels are and why you should use […]

Posted in General (talk) |

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

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

No Comments »

Song samples and lyrics

Monday, May 9th, 2005

We’ve added 2 nifty features for music lovers.

When you click view “Music Tracks”, we’ll provide a link to the page at Amazon.com so that you can find song samples from that album.

In addition, we’ve added song title links to Yahoo! that searches for lyrics.

Give it a try with this example - Norah Jones albums.

Posted in General (talk) |

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

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

No Comments »

Improved search history

Tuesday, May 3rd, 2005

A user wrote in to say that it’s often hard to remember what Asin and ISBN numbers mean in the saved search history.

Therefore, we have tweaked this feature a little, so that you can see the product name beside the Asin or ISBN number in future. Let’s hope this improves usability.

Posted in General (talk) |

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

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

No Comments »

Related searches

Sunday, May 1st, 2005

Now, whenever you search for something, we will give you other search terms that are related to it.

For example, try searching for madonna. A ‘Related searches’ link appears under the search box. Just move your mouse over it to see what happens.

One thing - the related searches may not yield you anything useful within […]

Posted in General (talk) |

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

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

No Comments »