failing to echo max with php and mysqli

Question

Thanks in advance for any help and understanding with the fact that I'm still very inexperienced...

Despite a long search through questions and examples, I still can't properly query/echo MAX.

If you could show me an exact example of the proper code I'd be very grateful.

Since I think I understand (?) you cannot mix mysql with mysqli, I'm going to provide here a sample of my code that actually works for purpose other than getting the max value:

$query = "SELECT iltr FROM massimo_demo_copy WHERE UPDT=3";
$result = $conn->query($query);
$row = mysqli_fetch_assoc($result);
$LTR = $row['iltr'];

echo "$LTR;

again, this code example works but it's not what I'm trying to do. What I am trying to do is get the maximum value from another column (points). I've tried too many syntax versions to list them...

I just wanna echo the max value from the points column with a mysqli syntax that is compatible with the example of the type of code above.

this is the first version I tried and it fails:

$query = "SELECT MAX(points) FROM massimo_demo_copy";
$result = $conn->query($query);
$row = mysqli_fetch_assoc($result);
$maxpts = $row['points'];

echo $maxpts;

I tried many others but lers start with that one

Thanks

We can't tell you what is wrong with your code if you don't show us the code that isn't working, please update your question to include the code you are having trouble with. — Epodax, Jul 07 '16 at 11:31
Why you are adding the working code ? . we don't need that , just give the code which is not working. — Arsh Singh, Jul 07 '16 at 11:34
why not to try to get exactly what you selected? namely $maxpts = $row['MAX(points)'] — Your Common Sense, Jul 07 '16 at 12:44
omg. of course. THANK YOU your common sense! it works. i'm an idiot, but hey... anyway thanks again, have a great one! — Took Zoxor, Jul 07 '16 at 13:11

Tomislav Škoda · Answer 1 · 2016-07-07T17:35:26.880

0

Your $query should look something like this SELECT MAX(points) as points FROM massimo_demo_copy

edited Jul 07 '16 at 17:35

answered Jul 07 '16 at 11:39

Tomislav Škoda

21
3

$query = "SELECT MAX(points) FROM massimo_demo_copy"; $result = $conn->query($query); $row = mysqli_fetch_assoc($result); $maxpts = $row['points']; echo $maxpts; – Took Zoxor Jul 07 '16 at 12:39
sorry i didnt know how to format in the comment section and accidentally posted. i put the same in the question. – Took Zoxor Jul 07 '16 at 12:43

score -1 · Answer 2 · edited Jun 12 '20 at 19:58

-1

If I understand your question, I resolved like this:

$example_max_value = "SELECT max(value) as max_value FROM table WHERE tableid={$var_ID}";
$get_result = mysqli_query($conectionDB,$example_max_value);
$get_result = mysqli_fetch_assoc($get_result);
$max_value = $get_result["max_value"];

Output:
max_value in the DB from table where table has the especifically range

edited Jun 12 '20 at 19:58

David Buck

3,752
35
31
35

answered Jun 12 '20 at 18:36

Juan_Menezes

1

failing to echo max with php and mysqli

2 Answers2