@John Andersen: thx but there has to be a solution instead of formatting in view file
@Azril Nazli: :-( no luck... it says, sql query error. here is the below query: SELECT `GenderSalutation`.`name`, `User`.`first_name`, `User`.`middle_name`, `User`.`last_name`, `User`.`address`, DATE_FORMAT (User.created, '%d') AS User.created, `User`.`mobile`, `User`.`dob`, `User`.`experience` FROM `users` AS `User` LEFT JOIN `gender_salutations` AS `GenderSalutation` ON (`User`.`gender_salutation_id` = `GenderSalutation`.`id`) WHERE `User`.`email` = '[email protected]' LIMIT 1 SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.created Any other solution... please help
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
