Geting max of a mysql field

[wepnop]

I need to get the max of the field called ID, from the table ordenador. This is my actual code:

$cons = "SELECT MAX(ID) FROM `ordenador`";
$maxrow = consultar_bd($cons);
$id_contiene = $maxrow['ID'];

 

consultar_bd is a function that executes a sql query and returns a fetched result as a array.

[Pikachu2000]

It seems you've neglected to ask a question . . .

[wepnop]

Sorry maybe its that my english is bad, but i think i asked it:

 

What  i need is to get the max of the ID value in the ordenador table using php + mysql.  Thats the code i was using but it dont works, when i try to get the ID it says that index dont exist.

 

I need some way to know and store in a php variable what is the higest ID value.

[lordshoa]

I sort of under stand can you do a orderby desc and the pick the first id so you get the highest number ?

 

Do you have a feild ID in the ordenador table or is it id

 

$cons = "SELECT `id` FROM `ordenador` ORDERBY DESC  LIMIT =1";

[wepnop]

I sort of under stand can you do a orderby desc and the pick the first id so you get the highest number ?

 

thanks, its working!

[lordshoa]

just have to click solved now.