How to show only the last row of database table

[doigax]

Hey. I'm new to php so this question may be very easy but still... I wrote a code for connecting to a database and show all of its records but I only need the last row, can someone please tell me what to add instead of the function 'foreach'. Here's the code:

<?php
 
$wpdb = new wpdb('username','password','database_name','localhost');
$result = $wpdb->get_results( "SELECT * FROM koridorius "); 
echo "TEMPERATŪRA"."  "."ŠVIESA"."<br><br>";
 
foreach($result as $row)
 {
echo $row->temperatura."  ".$row->sviesa."<br>";
 }
 
?>
 

[Dormilich]

How to show only the last row of database table

there is no last row in a database table.

to get a last row, you must apply sorting and then the last row is determined by the sort condition.

[doigax]

I have dates in the datebase so that I think could be the sort condition. But how to add sorting to the code?

[Dormilich]

sorting is the responsibility of the ORDER BY clause.

[doigax]

Thank you. The sorting works