something like this:
DROP TABLE IF EXISTS `mail_external`;
CREATE TABLE `mail_external` (
`id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`receiver` bigint(20) UNSIGNED NOT NULL,
`subject` varchar(200) DEFAULT 'Support Message',
`message` varchar(500) DEFAULT 'Support Message',
`money` int(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `mail_external_items`;
CREATE TABLE `mail_external_items` (
`id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`item` int(20) UNSIGNED NOT NULL DEFAULT '0',
`item_count` int(20) UNSIGNED NOT NULL DEFAULT '1',
`mail_id` int(20) UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
after you read the "id" from mail_external:
SELECT id, item, item_count WHERE mail_id = <id_here>
if you do a left-join it will return one row for each item, that means N mails with one item inside