Hi,
I want to save related data (create date, update date, comment) for
HBTM associated tables. Do I have to create my own SQL-Statement to get
this data or is there already something in cakephp that I could use
for?
the tables look like this
###
CREATE TABLE `companies` (
`id` int(11) NOT NULL auto_increment,
`name` text,
`searchname` text,
`orgform` text,
`street` text,
`zip` text,
`town` text,
`state` text,
`country` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_incremen ,
`abbreviation` varchar(64) default NULL,
`name` varchar(128) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `companies_members` (
`company_id` int(11) NOT NULL default '0',
`member_id` int(11) NOT NULL default '0',
`joined_at` date default NULL,
`left_at` date default NULL,
PRIMARY KEY (`company_id`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
####
Does anybody know how I could solve this issue or could point me to a
page where I could get the appropriate info.
Thanks in advance
derkaan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
