Assign MAX value of mysql field to php variable

Question

I want to assign the max value of a column in mysql to a variable in PHP. This ultimately will be to validate form data. Having trouble as I am new to PHP.

Tried this:

$result = mysql_query("SELECT MAX(receipt_id) FROM receipts");
if (!result) {
trigger_error(mysql_error($result));
}

$row = mysql_fetch_assoc($result);
$maxid = $row["receipt_id"];

echo "The max id is $row";

(The echo is just for testing). In this case the result was:

The max id Array

When I echo the $maxid variable in the above code there is no value returned in the echo.

And with this code:

$result = mysql_query("SELECT MAX(receipt_id) FROM receipts");
if (!result) {
    trigger_error(mysql_error($result));
}

echo "The max id is $result";

I get:

The max id is Resource id #2

What am I missing here?

Thanks in advance!

slash197 · Accepted Answer · 2014-01-26 06:23:10Z

5

Add an alias to the max sql function result:

SELECT MAX(receipt_id) AS max_value FROM receipts

Access it like any other value:

$row["max_value"]

answered Jan 26, 2014 at 6:23

slash197

9,0246 gold badges44 silver badges71 bronze badges

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

1 Comment

Joel LaRusic Over a year ago

Nice. Here is me kicking myself. Thanks.

Collectives™ on Stack Overflow

Assign MAX value of mysql field to php variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related