Jump to content

Archived

This topic is now archived and is closed to further replies.

Tmic

mysql and php max()

Recommended Posts

select max(nr) from tablename;

 

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

$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...

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.