Laravel Query -> FIRST();
<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>