This question may be unrelated to symfony, and more related to
database abstraction, but I'm wondering why I should pull the table
names from the model. I've been programming for a long time and have
never seen anyone need to use dyamic table names except when they have
prefixes on them that can change.
So, this is a pain to type out:
public static function getUserLabelsWithPasswordCounts($userId) {
$query = "SELECT
" . PasswordLabelPeer::NAME . ",
(SELECT COUNT(*) FROM " .
PasswordLabelPasswordsPeer::TABLE_NAME . " WHERE " .
PasswordLabelPasswordsPeer::LABEL_ID . " = " . PasswordLabelPeer::ID .
") AS pcount
FROM
" . PasswordLabelPeer::TABLE_NAME . "
WHERE
" . PasswordLabelPeer::ID . " = '$userId'
ORDER BY
" . PasswordLabelPeer::NAME . " ASC";
$con = Propel::getConnection();
$pdo = $con->prepare($query);
$pdo->execute();
return $pdo->fetchAll(PDO::FETCH_OBJ);
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
