Warning: Cannot use a scalar value as an array in /home/admin/public_html/forum/include/fm.class.php on line 757
Warning: Invalid argument supplied for foreach() in /home/admin/public_html/forum/include/fm.class.php on line 770
Warning: Invalid argument supplied for foreach() in /home/admin/public_html/forum/topic.php on line 737 Форумы портала PHP.SU :: Использование оператора AS в Kohana 3.2 (3.3)
SELECT*, addresses.last_name AS address_last_name, addresses.first_name AS address_first_name, users.last_name AS user_last_name, users.first_name AS user_first_name
FROM orders
LEFTJOIN addresses ON orders.address_id = addresses.id
Database_Exception [ 1054 ]: Unknown column 'addresses.last_name AS address_last_name' in 'field list' [ SELECT *, `addresses`.`last_name AS address_last_name`, `addresses`.`first_name AS address_first_name`, `users`.`last_name AS user_last_name`, `users`.`first_name AS user_first_name`, `order`.`id` AS `id`, `order`.`user_id` AS `user_id`, `order`.`token` AS `token`, `order`.`status` AS `status`, `order`.`address_id` AS `address_id`, `order`.`created` AS `created` FROM `orders` AS `order` LEFT JOIN `addresses` ON (`order`.`address_id` = `addresses`.`id`) LEFT JOIN `users` ON (`order`.`user_id` = `users`.`id`) ]
У меня предположение, может kohana не умеет обрабатывать оператор AS в select'e? Но как тогда сделать?
Все гости форума могут просматривать этот раздел. Только зарегистрированные пользователи могут создавать новые темы в этом разделе. Только зарегистрированные пользователи могут отвечать на сообщения в этом разделе.