mysql and php max()

[Tmic]

select max(nr) from tablename;

 

but I want to get the max(nr) in php. How can I do this?

[mtoynbee]

Please explain further, your question is unclear. Do you want to select the maximum value pulled from a list of items pulled from a database?

[Tmic]

Sorry for not being very clear.

 

When I do the following:

 

select max(nr) from table_test;

 

in mysql (via dosprompt) I get the result (f.i. 9)

 

now I try to do the same in php and normally I would do something like this:

 

$select = \"select nr from table_test\";

$result = mysql_query($select);

 

while($row = mysql_fetch_array($result)){

echo $row[\'nr\'];

}

 

but now its not nr but max(nr) but when I change all \'nr\' to \'max(nr)\' it doensnt seem to work.

 

I would like to now how I can get the value of max(nr) into a php variable. I think there is an easy way to do this but I\'m not seeing it.

[mtoynbee]

$select = \"select max(nr) AS max_nr from table_test\";

$result = mysql_query($select);

 

$max_nr = mysql_fetch_array($result);

 

Sorry if the last line needs tweaking as I\'m an ODBC man these days...

[Tmic]

THX mtoynbee

 

It works except for the last line like you said.

 

I did it like I normally do

 

while($row = mysql_fetch_array($result)){

$max = $row[\'max(nr)\'];

}

 

But I still think there must be a better way as there is only one result with max.