Hello,
I have several tables that have a common column. I need to check those tables for 1 of 4 items. If that item does not exist, I jump to a page saying it is coming soon...
I am passing a variable ($lang) around using php to select info based on that column.
what would be a suggested select statement be?
The database is small enough that I can search each table individually.
select lang from menus where lang <> $lang ?????
This is one of the tables.... trimmed as needed...
CREATE TABLE `menus` (
`id` int(5) NOT NULL auto_increment,
`lang` enum('Eng','Fre','Deu','Esp') NOT NULL default 'Eng',
`home` char(32) NOT NULL default '',
`products` char(32) NOT NULL default '',
`tech` char(32) NOT NULL default '',
`sales` char(32) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `language` (`lang`)
) TYPE=MyISAM;-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
