need help table join using mysql

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

[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:

$this->db->join('comments', ' =');

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

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

thnx Ruben
im try this but that not able to get two table value
pls say some ideas

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.