Re: mySQL: Query two tables for multiple results from array in first table?

[Presto]

Hello traq, thanks for the reply…

CREATE TABLE `qmzi_raceschedule_events` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ordering` int(11) NOT NULL,
`state` tinyint(1) NOT NULL DEFAULT ‘1’,
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`created_by` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`date` date NOT NULL,
`start_time` varchar(255) NOT NULL,
`description` text NOT NULL,
`options` varchar(255) NOT NULL DEFAULT ”,
PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8

CREATE TABLE `qmzi_raceschedule_options` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ordering` int(11) NOT NULL,
`state` tinyint(1) NOT NULL DEFAULT ‘1’,
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`created_by` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`eventid` text NOT NULL,
PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8