You asked how to show a row but then your sql is only getting a single value. Assuming you want the max date from the table or NULL if there is only a single record one way to do it is like this:
IF (SELECT COUNT(*) FROM table) <= 1
BEGIN
SELECT NULL AS myDate
END
ELSE
BEGIN
SELECT MAX(date_field) AS myDate
FROM table
END
Put this in a stored procedure, don't try to do it as inline sql in php.
Quote:
one row in table show max row and min row is same
Which is perfectly fine because that IS the correct data.