i have 5 tables like these
1). purchases
2). purchase_details
- purchase_id
- item_id
3). items
4). purchase_item_details
- purchase_detail_id
- item_detail_id
5). item_details
- item_id
in an action, i have to do more than one save action. rule
1). save data into purchases
2). get last insert id from table purchases
3). save data into items
4). get last insert id from table items
5). save data into purchase_details with those two variables
( purchase_id & item_id )
6). get last insert id from table purchase_details
7). save data into item_details with item_id
8). get last insert id from table item_details
9). save data into purchase_item_detail with those two variables
( purchase_detail_id & item_detail_id )
so.. i get a problem at rule #3... it cannot save, dont know why, i
have no error message at my web
items table
CREATE TABLE IF NOT EXISTS `items` (
`id` int(11) NOT NULL auto_increment,
`item_type_id` int(11) NOT NULL,
`item_brand_type_id` int(11) NOT NULL,
`desc` text NOT NULL,
`info` text NOT NULL,
`default_price` int(11) NOT NULL,
`entry_date` date NOT NULL,
`entry_by` int(11) NOT NULL,
`update_date` date NOT NULL,
`update_by` int(11) NOT NULL,
`f_expired` enum('t','f') NOT NULL,
`f_return` enum('t','f') NOT NULL,
`f_active` enum('t','f') NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
please help me...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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?hl=en
-~----------~----~----~----~------~----~------~--~---
