Re: Manual entry for habtm linking table.

2011-09-19 Thread WebbedIT
I hope you stick with it and find it a viable alternative to CodeIgniter. I have never used another framework, but I'm yet to find something that CakePHP can't do and none of my clients ever complain about speed, in fact they comment how my CakePHP sites seem faster than my older raw PHP sites.

Re: Manual entry for habtm linking table.

2011-09-19 Thread Ritesh R Aryal
Thanks WebbedIT ! it has helped me too. cheers On Sep 19, 8:06 am, WebbedIT p...@webbedit.co.uk wrote: I hope you stick with it and find it a viable alternative to CodeIgniter.  I have never used another framework, but I'm yet to find something that CakePHP can't do and none of my clients ever

Re: Manual entry for habtm linking table.

2011-09-18 Thread porangi.chris
Thanks Paul, First time for me in Cake, normally use WP and Codeigniter but wanted to try out the baking. I was trying to over complicate it with: $db_data = array( 'teacher_id' = $teacher['Teacher']['id'], 'tclass_id' =

Re: Manual entry for habtm linking table.

2011-09-16 Thread WebbedIT
If using Cakes HABTM automagic the table should be named classes_teachers and have the following fields id (primary_key, auto_inc) class_id teacher_id After that it's a case of INSERT INTO classes_teachers (class_id, teacher_id) SELECT class_id, teacher_id FROM import_table HTH, Paul @phpMagpie

Manual entry for habtm linking table.

2011-09-15 Thread porangi.chris
hi, First time user of cake with CI background, I have two tables teachers and classes that share a many to many relationship e.g. Teacher-Classes. I'm having to import the data from CSV files that have been exported from another system that we have limited access to.I've got the classes