Jump to content


Photo

mysql and php max()


  • Please log in to reply
4 replies to this topic

#1 Tmic

Tmic
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 18 November 2003 - 09:49 AM

select max(nr) from tablename;

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

#2 mtoynbee

mtoynbee
  • Members
  • PipPipPip
  • Advanced Member
  • 111 posts
  • LocationHythe, SE England

Posted 18 November 2003 - 12:54 PM

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?

#3 Tmic

Tmic
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 18 November 2003 - 01:18 PM

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.

#4 mtoynbee

mtoynbee
  • Members
  • PipPipPip
  • Advanced Member
  • 111 posts
  • LocationHythe, SE England

Posted 18 November 2003 - 02:39 PM

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

#5 Tmic

Tmic
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 20 November 2003 - 09:35 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users