MySQL Query

Hi, I would like to put a condition in a query, but I do some things wrong, what is it?

$id = 1;

$groups = DB::table('table_example')
      if($id!='0'){
          ->where('id', '=', $id)
         }
      ->limit(30)
      ->get();

Best regards

Best Answer

Level 23

$id = 1;

$groups = DB::table('table_example');

 if($id!='0') {
     $groups->where('id', '=', $id)
 }

  $groups->limit(30)->get();

Try that.

1 like

Level 1

@wilburpowery It's "working", now I have another problem doing this...

Best regards

Please or to participate in this conversation.