public function action_joinquery()
{
$data=DB::select('posts.postTitle','posts.postBody','authors.author_name')
->from('posts')
->join('authors')->on('posts.authorId','=','authors.author_id')
->execute();
// echo Debug::dump( $q);
echo View::factory('database')>bind('data',$data);
}
{
$data=DB::select('posts.postTitle','posts.postBody','authors.author_name')
->from('posts')
->join('authors')->on('posts.authorId','=','authors.author_id')
->execute();
// echo Debug::dump( $q);
echo View::factory('database')>bind('data',$data);
}
No comments:
Post a Comment