Laravel query not returns all values

Question

I'm trying to make simple forum on laravel. I have two tables: categories:

forums:

I run query:

$categories = DB::table('forums')
        ->join('categories', 'forums.fid', '=', 'categories.cid')
        ->select('categories.*', 'forums.*')
        ->get();

I receive only two results:

[{"cid" :1,
  "name": "First forum",
  "fid": 1,
  "seo_name": "first-forum",
  "category_id": 1
 },
 {"cid": 2,
  "name": "Another forum",
  "fid": 2,
  "seo_name": "another-forum",
  "category_id": 2
 }]

Why only 1 result for category_id 1? I have two forums in that category. Thanks in advance and sorry for my bad English.

You should have spent the time you wasted here on creating this question on debugging. Try to learn debugging on your own. That is the most important thing for a programmer. :) — masud_moni
– masud_moni, Commented Dec 5, 2017 at 12:31

Webdesigner · Accepted Answer · 2017-10-08 19:47:32Z

2

You need:

->join('categories', 'forums.category_id', '=', 'categories.cid')

answered Oct 8, 2017 at 19:47

Webdesigner

1,9921 gold badge11 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mizanur Rahman · Accepted Answer · 2017-12-05 12:27:48Z

1

Update query to:

$categories = DB::table('forums')
        ->join('categories', 'forums.category_id', '=', 'categories.cid')
        ->select('categories.*', 'forums.*')
        ->get();

answered Dec 5, 2017 at 12:27

Mizanur Rahman

3464 silver badges7 bronze badges

Collectives™ on Stack Overflow

Laravel query not returns all values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related