how to use max(id) in OOP Class?

[spires]

Hi

 

I can't seem to return the MAX position of my data in the MYSQL database.

 

Class

public static function find_last_pos(){
	 global $database;
	 $sql = "SELECT max(position) as max_position FROM ".self::$table_name." LIMIT 1";
	 $result_array = self::find_by_sql($sql);
	 return $result_array[0]->max_position;
}

 

HTML

$POS = Blog_categories::find_last_pos();
echo $POS;

 

 

Where am I going wrong?

 

 

*note, the class works fine if I select * rather than max()

 

Thanks

[Simmo]

Hi

 

I do something similar when I want just the one record but use this line:

 

return !empty($result_array) ? array_shift($result_array) : false;

 

 

[spires]

Yeah, I tried that first. Does not work either.

 

Thanks, any other ideas?

[beegro]

What version of MySQL are you using?

[spires]

Server version: 5.0.51a-3ubuntu5.4

[beegro]

I think this may be an issue with the first implementation of MAX in MySQL 5. 

 

See: http://bugs.mysql.com/bug.php?id=36300

 

Of course, you could always rewrite the query like this: 

 

$sql = "SELECT position FROM ".self::$table_name." ORDER BY position ASC LIMIT 1";

 

[Anti-Moronic]

This isn't OOP. You're using static classes is all.