how to get max value of a sql database query in php

Question

I want to find out the max value of sql data column on the basis of email id and username. (there is no primary entity) To get the email id, i store the user email id from session.

here goes my code:

$emailid = $userRow['emailid'];

$sql = "select max(item) from product where email = '$emailid' AND username = 'arun'";

$result = $conn-> query($sql);

$row = $result->fetch_assoc();
echo "Max item : " .$row['result'];

It's giving me first value of sql table but not highest.

"SELECT MAX(item) AS result FROM product WHERE email = '$emailid' AND username = 'arun'" try this — Jees K Denny
– Jees K Denny, Commented Aug 8, 2016 at 9:07
$sql = "select item from product where email = '$emailid' AND username = 'arun' order by item desc limit 1"; ? — Professor Abronsius
– Professor Abronsius, Commented Aug 8, 2016 at 9:18
Possible duplicate of SELECT MAX(... not returning anything in PHP/MYSQL — Jees K Denny
– Jees K Denny, Commented Aug 8, 2016 at 9:20

Rohan Khude · Accepted Answer · 2016-08-08 09:06:17Z

0

you can either change your column data-type or use CAST or CONVERT.

$sql = "SELECT MAX( CAST( `item` AS UNSIGNED) ) as max FROM `product` WHERE `email` = '$emailid' AND `username` = 'arun'";

If possible its better to change the data-type.

answered Aug 8, 2016 at 9:06

Rohan Khude

5,0015 gold badges52 silver badges48 bronze badges

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

Comments

Jees K Denny · Accepted Answer · 2016-08-08 09:11:27Z

0

Try this,

$emailid = $userRow['emailid'];
$sql = "SELECT MAX(item) AS item FROM product WHERE email = '$emailid' AND username = 'arun'";
$result = $conn-> query($sql);
$row = $result->fetch_assoc();
echo "Max item : " .$row['item'];

answered Aug 8, 2016 at 9:11

Jees K Denny

5276 silver badges27 bronze badges

Comments

Hiren Makwana · Accepted Answer · 2016-08-08 09:28:10Z

0

Try this way,

$rowSQL = mysql_query( "SELECT MAX( ID ) AS max FROM `tableName`;" );
$row = mysql_fetch_array( $rowSQL );
$largestNumber = $row['max'];

answered Aug 8, 2016 at 9:28

Hiren Makwana

2,1462 gold badges16 silver badges30 bronze badges

Collectives™ on Stack Overflow

how to get max value of a sql database query in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related