I'd like some advice on setting up databases that contain entries for
the same item in more than one language. For instance, here's what I
currently do for a table that contains the same topics translated into
English and Arabic:
CREATE TABLE `TOPIC` (
`TopicID` int(11) NOT NULL auto_increment,
Thanks, again, for folks who suggested solutions to my problem. To help
users searching the archives, I've pasted in a working solution at the
end of this message. Also, I'd like to ask if there is a more efficient
or better way of checking if the language version exist than the six
lines I repeate
y AS m
JOIN subcategory AS s ON m.maincatid=s.maincatid
JOIN baseitem AS b ON s.subcatid=b.subcatid
WHERE
b.available = "Y"
ORDER BY m.title, s.title;
[EMAIL PROTECTED]:~$ mysql orderDB mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 12:45 PM
To: Zembower, Kevin; mysql@lists
I'm trying to use a subquery for the first time, and am having some
problems. I'm hoping someone can give me some suggestions on ways of
doing what I want, and further suggestions if there's a better way of
going about my task.
I have a database of publications in different languages. "main
catego