hi, i don't know how to do this sql:
select u.id,email as userName,sum(adjective_value) as
totle,q.question_text
from sdq_sdq_adjectives as ad,sdq_sdq_answers as a,sdq_sdq_questions
as q,sdq_sdq_users as u
where a.adjective_id=ad.id and ad.question_id=q.id and a.user_id=u.id
group BY q.id,u.email order by u.id,q.id
here are my models as well as db structure:
<?php
class Adjective extends AppModel
{
var $name = 'Adjective'; // This is the name of your database table
var $belongsTo = array("Question" => array(
"className" =>
"Question",
"foreignKey" =>
"question_id"
)
);
}
?>
<?php
class User extends AppModel
{
var $name = 'User'; // This is the name of your database table
var $hasMany = array("Answer" => array(
"className" => "Answer",
"foreignKey" => "user_id"
)
);
var $validate = array('email' => VALID_EMAIL);
}
?>
<?php
class Question extends AppModel
{
var $name = 'Question'; // This is the name of your database table
var $hasMany = array("Adjective" => array(
"className" => "Adjective",
"foreignKey" => "question_id"
)
);
}
?>
<?php
class Answer extends AppModel
{
var $name = 'Answer'; // This is the name of your database table
var $belongsTo = array("User" => array(
"className" => "User",
"foreignKey" => "user_id"
)
);
}
?>
CREATE TABLE `sdq_b2b_adjectives` (
`id` int(10) unsigned NOT NULL auto_increment,
`question_id` int(10) unsigned NOT NULL default '0',
`adjective_text` varchar(255) NOT NULL default '',
`adjective_order` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=30 ;
CREATE TABLE `sdq_b2b_answers` (
`id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL default '0',
`adjective_id` int(10) unsigned NOT NULL default '0',
`adjective_value` int(10) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=89 ;
CREATE TABLE `sdq_b2b_questions` (
`id` int(10) unsigned NOT NULL auto_increment,
`question_text` varchar(255) NOT NULL default '',
`question_description` varchar(255) NOT NULL default '',
`question_order` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;
CREATE TABLE `sdq_b2b_users` (
`id` int(10) unsigned NOT NULL auto_increment,
`ip` varchar(15) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`sex` enum('male','female') NOT NULL default 'male',
`education` int(10) unsigned NOT NULL default '0',
`age` int(10) unsigned NOT NULL default '0',
`income` int(10) unsigned NOT NULL default '0',
`job` int(10) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
