i'm trying to update the 'hours_worked' column in "daiy_attendance" table using 'in_time' and 'out_time' in same table. in_time and out_time already stored in the table.so im using timediff to get the difference.query runs and execute correctly when i try it on the phpmyadmin sql format.but when i try to run it in the programme it does not update the 'hours_worked' column.it does not gives any errors also.
$sql5 = "UPDATE daily_attendances SET hours_worked = TIMEDIFF(out_time,in_time) WHERE in_time != '' AND out_time != '' ";
$result2 = DB::statement(DB::raw($sql5));
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2hiErNe
via IFTTT
We are a third party technical support service. Avast Customer Support is here to help you out with the whole procedure to Download Avast Antivirus online, We not only fix your Avast Support related issues but will guide with how to get started with your new Avast product once it gets installed successfully.We at Avast Tech Support provides service to protect your PC from potential online threats and external attacks like viruses, Trojans, malwares, spywares and phishing scams. And Avast Refund. Call on our Avast Phone Number.
RépondreSupprimer