get maximum from a table in mysql

Question

I want to get or fetch maximum date from a table grouped by party_id.

To do this I tried:

$check = mysql_fetch_array(mysql_query("select max(fixed_date) as f from case_proceeding group by party_id where party_id='$row[party_id]'"));

After that, I want to print that maximum date like this:

echo $check['f'];

but it does not work. I think there is a mistake in the mysql_query.

group by goes after where. instead of putting it on on one line, breaking it down so you can use error checking is advised — , Nov 28 '12 at 06:21
[**Please, don't use `mysql_*` functions in new code**](http://bit.ly/phpmsql). They are no longer maintained and the [deprecation process](http://j.mp/Rj2iVR) has begun on it. See the [**red box**](http://j.mp/Te9zIL)? Learn about [*prepared statements*](http://j.mp/T9hLWi) instead, and use [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli) - [this article](http://j.mp/QEx8IB) will help you decide which. If you choose PDO, [here is a good tutorial](http://j.mp/PoWehJ). — NullPoiиteя, Nov 28 '12 at 06:29

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

try, GROUP BY (which should come after WHERE clause) isn't needed here since you already filtered from WHERE

$check = mysql_fetch_array(mysql_query("select max(fixed_date) as f from case_proceeding where party_id='$row[$party_id]'"));

but your quesry is vulnerable with SQL Injection, please read the article below to protect against it

edited May 23 '17 at 10:24

Community

answered Nov 28 '12 at 06:21

John Woo

score 0 · Answer 2 · answered Nov 28 '12 at 06:22

0

try this:

GROUP BY clause is not required here

select max(fixed_date) as f 
from   case_proceeding 
where  party_id='$row[party_id]

answered Nov 28 '12 at 06:22

Joe G Joseph

score 0 · Answer 3 · answered Nov 28 '12 at 06:22

0

Try this ::

select max(DATE(fixed_date)) as f from case_proceeding where party_id=? group by party_id

answered Nov 28 '12 at 06:22

Sashi Kant

score 0 · Answer 4 · answered Nov 28 '12 at 06:23

0

try

$check = mysql_fetch_array(mysql_query("select max(fixed_date) as f from case_proceeding where party_id='$row[party_id]' "));

Note :mysql_* function are deprecated so try pdo or mysqli

answered Nov 28 '12 at 06:23

NullPoiиteя

4 Answers4