I want to echo record that has a MAX Value in php,So how i do that?
I have table like this:
1 | 3
2 | 1
SELECT MAX(value) FROM user
If you need only one row with actual data you should use another appoach with sorting and limit. See code below:
SELECT * FROM user order by value desc limit 1;