SELECT MAX(... not returning anything in PHP/MYSQL

Question

This is the table structure-

Table: test

+------+---------+
| PAGE | CONTENT |
+------+---------+
|  1   |   ABC   |
+------+---------+
|  2   |   DEF   |
+------+---------+
|  3   |   GHI   |
+------+---------+

PAGE is a Primary with datatype INT(11). It does not auto-increment. CONTENT is of the datatype TEXT.

In PHP I do-

$result = mysql_query(SELECT MAX(PAGE) FROM test);
$row = mysql_fetch_array($result);
echo $row["PAGE"];

No output. At all. If I do something like echo "Value : ".$row["PAGE"]; all I see is Value :

The query SELECT * FROM test works just fine though. Am I wrong somewhere using the MAX() syntax?

I want it to return the maximum value of PAGE as of yet.

Everything seems all right..could you try using this query SELECT MAX(PAGE) as PAGE FROM test instead and see if theres any difference? — Jagmag
– Jagmag, Commented Sep 15, 2012 at 7:14
Thanks a lot. It works. Been struggling with this for a long time. — Samik Sengupta
– Samik Sengupta, Commented Sep 15, 2012 at 7:16
Please stop writing new code with the ancient mysql_* functions. They are no longer maintained and community has begun the deprecation process. Instead you should learn about prepared statements and use either PDO or MySQLi. If you care to learn, here is a quite good PDO-related tutorial. — user1233508
– user1233508, Commented Sep 15, 2012 at 7:16

FluffyJack · Accepted Answer · 2012-09-15 07:15:11Z

18

This should be the code.

$result = mysql_query("SELECT MAX(PAGE) AS max_page FROM test");
$row = mysql_fetch_array($result);
echo $row["max_page"];

answered Sep 15, 2012 at 7:15

FluffyJack

1,73210 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

paxdiablo · Accepted Answer · 2012-09-15 07:15:27Z

2

Shouldn't you have quotes around that query in mysql_query? I have no idea what PHP will do with such a syntactically inadequate statement, I would have thought it would have given you an error.

In any case, an aggregate function may have a different column name than the column used for it (from memory, DB2 gives it a similar name to the function, like max_page_ or something). You may want to ensure it has the correct column name by forcing the name with something like:

$result = mysql_query("SELECT MAX(PAGE) AS MAXPAGE FROM TEST");
$row = mysql_fetch_array($result);
echo $row["MAXPAGE"];

answered Sep 15, 2012 at 7:15

paxdiablo

889k243 gold badges1.6k silver badges2k bronze badges

1 Comment

FluffyJack Over a year ago

I think he just mistyped it, as he'd be getting an error not just nothing otherwise.

Vijai Sebastian · Accepted Answer · 2016-12-31 12:56:03Z

1

Try below code

$result = mysqli_query($con,"SELECT max(page2_content_id) AS max_page from page2_content_data");
$row = mysqli_fetch_array($result);
echo $row["max_page"];

Where $con=new mysqli($server,$user,$password,$db_name); and page2_content_data is my table,and page2_content_id is the column name

edited Dec 31, 2016 at 12:56

answered Dec 30, 2016 at 20:26

Vijai Sebastian

1252 silver badges4 bronze badges

1 Comment

trincot Over a year ago

Users of SO can order answers in several ways, so speaking of "above answer and below" is mostly meaningless.

jmattheis · Accepted Answer · 2016-08-10 18:21:22Z

0

$connect = mysqli_connect("localhost", "root", "", "carBid") or die("not connected");

//connection to database
$sql2 = "SELECT max(mybid) FROM `bid`";

//simle select statement with max function
$result_set2 = mysqli_query($connect,$sql2);

//query a result fetch
if ($result_set2) {
    $rowB = mysqli_fetch_array($result_set2);
    //feching a result in array format
    echo $rowB['max(mybid)'];
    //accessing array by name of column with max() function of mysql
} else {
    echo 'No Current Bid';
}
mysqli_close($connect);

edited Aug 10, 2016 at 18:21

jmattheis

11.2k12 gold badges52 silver badges62 bronze badges

answered Nov 19, 2015 at 9:18

im-sunil

4344 silver badges9 bronze badges

4 Comments

Cleb Over a year ago

There is one "{" too much or too less, I think.

Francesco Casula Over a year ago

Just a quick note. mysql_query and mysql_fetch_array are deprecated.

Tobias Liefke Over a year ago

While this code may answer the question, it would be better to explain how it solves the problem and why to use it. Code-only answers are not useful in the long run.

im-sunil Over a year ago

<?php $connect= mysqli_connect("localhost", "root", "", "carBid") or die("not connected"); //connection to database $sql2 = "SELECT max(mybid) FROM bid"; //simle select statement with max function $result_set2 = mysqli_query($connect,$sql2); //query a result fetch if ($result_set2) { $rowB = mysqli_fetch_array($result_set2); //feching a result in array format echo $rowB['max(mybid)']; //accessing array by name of column with max() function of mysql } else { echo 'No Current Bid'; } mysqli_close($connect); ?>

Bruce Ballad · Accepted Answer · 2018-09-11 07:49:08Z

0

I used something like this in my code;

$maxscore_query = mysql_query("SELECT MAX(`score`) FROM `allscores` WHERE`level`='$levelcode'");

echo mysql_result($maxscore_query, 0);

The difference here is the use of WHERE for selecting a group.

And mysql_result($maxscore_query, 0); is easier to manage for me.

answered Sep 11, 2018 at 7:49

Bruce Ballad

1062 silver badges6 bronze badges

Collectives™ on Stack Overflow

SELECT MAX(... not returning anything in PHP/MYSQL

5 Answers 5

Comments

1 Comment

1 Comment

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related