title: Laravel Query -> FIRST();
body: <p>I am struggling with a query! In my SQL Server I put <code>first();</code> instead of <code>get();</code> and I get the last result so in <strong>LARAVEL 4.2</strong> I get an error. Do you have any advice? Is there a different way to do this? I will give you the code in case you need more information.
  Thank you for your time!</p>
  
  <pre><code>$users = DB::table('Home_Students')
              -&gt;select('home_firstname','home_lastname','LogSt_data','LogSt_date')
              -&gt;join('Home_LogStudents','Home_LogStudents.LogSt_studid','=','Home_Students.home_id')
              -&gt;join('LessonUnitSections','LessonUnitSections.leuns_ID','=','Home_LogStudents.LogSt_sectionID')
              -&gt;join('LessonUnits','LessonUnits.leun_ID','=','LessonUnitSections.leuns_LessonUnitID')
              -&gt;where('Home_LogStudents.LogSt_action','=',225)
              -&gt;where('Home_LogStudents.LogSt_data','&lt;&gt;',0)
              -&gt;where('Home_LogStudents.LogSt_sectionID','=',$id)
              -&gt;orderBy('LogSt_date','home_firstname')
              -&gt;get();
  </code></pre>