On 1/30/07, Devraj Mukherjee <[EMAIL PROTECTED]> wrote:
> I have the following tables
I had asked you to read the Cake Conventions about database names and
field names :)
> - Supply, identified by supplier ID and holds details of a supply
> - A user with username as the PK
> - A Order that contains many OrderLines
> - OrderLine is for a Supply and a qty
The way you are describing the above tables still does not follow the
cake conventions. Its not that you will not be able to use the tables
without following the cake naming conventions but it will be
difficult.
To illustrate it better - if in your case a User hasMany Order - the
table will be
[users] => Array
(
[id] => 1
[username] => devraj
[password] => password
.....
)
[orders] => Array
(
[id] => 23
[user_id] => 1
......
)
Try to refactor your tables to fit proper cake associations and you
will be able to bake the whole thing in no time
Use some ER tool (DBdesigner4) or better a whiteboard / paper to
visualize the relationships
HTH
Tarique
--
=============================================================
PHP for E-Biz: http://sanisoft.com
Cheesecake-Photoblog: http://cheesecake-photoblog.org
=============================================================
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
