need help table join using mysql

#1
[eluser]vadivel[/eluser]
hi frnds
im now begin to learn ci
im need ur help, how to join more then two table
in mysql pls any one tell me with example
thanks in advance

#2
[eluser]Ruben Müller[/eluser]
It would be easier if you post your query and which tables you want to join. Smile

But basically it´s just:

Code:
$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');

$query = $this->db->get();

// Produces:
// SELECT * FROM blogs
// JOIN comments ON comments.id = blogs.id

#3
[eluser]vadivel[/eluser]
thnx Ruben
im try this but that not able to get two table value
pls say some ideas

#4
[eluser]vadivel[/eluser]
hi frnd
im solve the join proplam now im want join five table
how it's make it, any one say me


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.