sql - using two inner join in mysql query -


i have 2 tables below pictures :

users table :

enter image description here

offer_comments

enter image description here

offer_comments table stores comments , answer comments. using below function can comments , answer comments depending on $id.

function getcommentsanitem($id){      mysql_query("set character set utf8");     $result_comments = mysql_query("select e.comment comment,m.comment answer_to_comment      offer_comments e      inner join offer_comments m on e.id = m.quet      e.offer_id=$id , e.confirm=1");     $comments = array();     while($a_comment=mysql_fetch_object($result_comments)){          $comment = array(         'comment'=>$a_comment->comment,         'answer'=>$a_comment->answer_to_comment         );         array_push($comments,$comment);     }      return $comments ; }

now,i use inner join instead of offer_comments, how can ? use below sql instead of offer_comments :

select offer.*,u.id,u.name,u.family offer_comments offer         inner join users u on offer.id=u.id

like :

    $result_comments = mysql_query("select e.comment comment,m.comment answer_to_comment      (select offer.*,u.name,u.family offer_comments offer     inner join users u on offer.id=u.id) e      inner join offer_comments m on e.id = m.quet      e.offer_id=$id , e.confirm=1");

but returns [] !!

try this:

   $result_comments = mysql_query("select e.comment comment,m.comment answer_to_comment      (select offer.*,u.name,u.family offer_comments offer     inner join users u on offer.user_id=u.id) e      inner join offer_comments m on e.id = m.quet      e.offer_id=$id , e.confirm=1");

the change here in e derived table relation between users , offer_comments should users.id = offer_comments.user_id , you've done users.id = offer_comments.id


Comments

Post a Comment

Popular posts from this blog

Python Kivy ListView: How to delete selected ListItemButton? -

Image
i'm trying learn kivy building simple todo-list app suggested dusty phillips, author of book "creating apps in kivy". this code far: from kivy.app import app kivy.uix.boxlayout import boxlayout kivy.properties import objectproperty kivy.uix.listview import listitembutton class taskbutton(listitembutton): pass class todoroot(boxlayout): task_input = objectproperty() task_list = objectproperty() def add_task(self): self.task_list.adapter.data.extend([self.task_input.text]) self.task_list._trigger_reset_populate() def del_task(self): pass class todoapp(app): def build(self): return todoroot() if __name__ == '__main__': todoapp().run() and kv file: #: import main todo #: import listadapter kivy.adapters.listadapter.listadapter #: import listitembutton kivy.uix.listview.listitembutton todoroot: <todoroot>: orientation: "vertical" task_input: task_input_view t...
Read more

ruby - How do I merge two hashes into a hash of arrays? -

http://codepad.org/wmyzqlis i'd merge these 2 arrays: a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } into hash looks this: {:a => ["a", "1"], :b => ["b", "b"], :c => [nil, "c"], :d => ["d", nil] } this doesn't work: p a.merge(b) { |k, v1, v2| [v1, v2] } # {:c=>"c", :a=>["a", "1"], :b=>["b", "b"], :d=>"d"} it's because hash#merge call block duplicate keys. a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } hash[(a.keys|b.keys).map { |key| [key, [a.fetch(key, nil), b.fetch(key, nil)]] }] # => {:a=>["a", "1"], :b=>["b", "b"], :d=>["d", nil], :c=>...
Read more