1 reply to this topic

[lol33d]

Hi guys

I get contents from a website and store to table of database.

Every word of this content need translate, my translates is in another table.

i need a solution for better translate for contents

and i need a query for this.

my tables:

CREATE TABLE IF NOT EXISTS `webstrore` (

	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

	`content` text NOT NULL DEFAULT '',

	`datetime` datetime NOT NULL,


	PRIMARY KEY (`id`)

) ENGINE=MyISAM;


CREATE TABLE IF NOT EXISTS `weblanguage` (

	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

	`webstrore_id` bigint(20) unsigned NOT NULL DEFAULT '0',

	`word` varchar(255) NOT NULL DEFAULT '',

	`translateword` varchar(255) NOT NULL DEFAULT '',

	`datetime` datetime NOT NULL,


	PRIMARY KEY (`id`)

) ENGINE=MyISAM;

thank you

[BlaineSch]

Have you tried this:
Google Translate API v2 - Google Code