تالار گفتمان nCIS.ir

echo $post->user->name;
echo $post->category->name;

SELECT * FROM `posts` `p`
LEFT JOIN `categories` `c` ON `c`.`id`=`p`.`category_id`
LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id`

SELECT * FROM `posts`
LEFT JOIN `categories` ON `categories`.`id`=`posts`.`category_id`
LEFT JOIN `users` ON `users`.`id`=`posts`.`user_id`

SELECT * FROM `posts` WHERE (`visile` = '1' ) ORDER BY `id` DESC LIMIT 5

SELECT * FROM `posts` `p`
                                           LEFT JOIN `categorise` `c` ON `c`.`id`=`p`.`category_id`
                                           LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id`
                       WHERE (`visile` = '1' ) ORDER BY `id` DESC LIMIT 5