Get result from mysql query

[Lassie]

I have a query that I want to get the value from and put into a variable.

My query is

$result =$wpdb->get_results("SELECT MAX(`mapid`) 

FROM  `sw_mappress_maps` 

ORDER BY  mapid DESC 

LIMIT 1");

if(!$result) echo"No result";

if($result) echo "Result";

var_dump($result);

I get a result so i assume query is Ok, but I can't access the result

var_dump gives

 

array
0 =>
object(stdClass)[402]
public 'MAX(`mapid`)' => string '28' (length=2)

 

28 is the value I want from field mapid

but the foreach gives nothing.

Any suggestions appreciated.

 

       foreach( $result as $results ) {

        echo $results->mapid;

         }

 

[trq]

Change:

 

 

SELECT MAX(`mapid`) 

 

to

 

SELECT MAX(`mapid`) AS maxMapid

 

Then access via:

 

$result->maxMapid;

[Lassie]

Thanks, that works. Whats the thinking here?