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 (7,6,5,4,3,2) GROUP BY ID

2005 April | TicTap Blog

Archive for April, 2005

TicTap UI needs improvement

Friday, April 29th, 2005

Damon and I have been talking about the look and feel of TicTap.

While we like to keep it simple and clean, we think it might look a little more professional.

However, we’re not web designers, and although the site was (painstakingly!)created with a text editor, it might be time to get outside help.

So let us hear […]

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

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

No Comments »

People-specific search

Friday, April 29th, 2005

Using TicTap, you can now search by authors, singers, songs, actors and directors.

Simply type in their names!

Alternatively, you can type “author:Stephen King” in the search box.

Here are all the keywords to use:

author:
song:
singer:
actor:
actress:
director:

You can also use the keyword “artiste:” as a substitute for actor, actress, singer and director.

This works even from the url. For example […]

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

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

No Comments »

Automatic spelling hints

Wednesday, April 27th, 2005

It’s not uncommon for me to misspell words.

Really, how many of us can spell the California Governor’s last name correctly?

That is why TicTap has a new ‘Did You Mean’ feature. When it detects a possible spelling error it will offer an alternative.

For example, try Arnold Scwarseneger.

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

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

No Comments »

Customer reviews word summary

Saturday, April 23rd, 2005

We made some changes to the way customer reviews are presented today.

Now, you will see a list of words at the top of each reviews page. These words are typical words that you’d use to describe a product. For example, ‘Excellent, great, highly recommended, lousy, waste of money, fair, average’ etc…

If you have […]

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

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

No Comments »

New design and features

Wednesday, April 20th, 2005

We just updated TicTap today.

The most significant improvements were made to the user interface of TicTapWeb and the introduction of labels.

Among the UI improvements,

Saved searches.
You can search directly from the URL! Try http://www.tictap.com/s/lord of the rings to see what I mean.
We’ve color-coded the prices for faster navigation.
A permanent link URL is […]

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

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

No Comments »

TicTap Beta Launch

Saturday, April 2nd, 2005

Woo hoo.. We’ve finally launched TicTap. TicTap is a price hunting service. It lets you hunt for product prices over the hand phone or through the web.

Information is provided by Amazon.com.

We’ll be rolling out new features and revisions very often and this blog will be the place to read about what we […]

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

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

No Comments »