is it possible to return 2 values from this?
I want that HAVING clause have maximum of two.
$sql = mysql_query("
SELECT *
FROM
`Bill`
WHERE
ID_Number='12345'
HAVING
max(`Pay_Date`)
ORDER BY
`Pay_Date`
DESC LIMIT 2");
you can order the result by pay_date instead.
$sql = mysql_query("
SELECT *
FROM
`Bill`
WHERE
ID_Number='12345'
ORDER BY
`Pay_Date`
DESC LIMIT 2");
This should work because you will be ordering the results by pay_date in desc. order. So the latest two dates will be displayed.