Форум PHP программистов ► PHP практикум ► PHP + SQL

$sqlmaxbidy2="SELECT MAX(bid) AS `maximum`, idn AS `idn` FROM `table` ";
print "<br>".$sqlmaxbidy2;
$resmaxbid2=mysql_query($sqlmaxbidy2);
$linebid2 = mysql_fetch_array($resmaxbid2, MYSQL_ASSOC);
$maxbidfirst2=$linebid2['maximum'];

count   name   idn        date
 10       Alex   2343    01.01.11  12.10
 20       Alex   2223    01.01.11  12.11
 20       Alex   2546    01.01.11  12.12
 10       Alex   2543    01.01.11  12.13

20       Alex   2223    01.01.11  12.11

SELECT * FROM `tbl`
WHERE bid = (
    SELECT MAX(bid) AS `maximum`, idn AS `idn` FROM `table` 
)

SELECT MAX(count), name, idn, date
FROM `table`
ORDER BY date LIMIT 1

SELECT *
FROM `table`
ORDER BY `count` DESC, `date` ASC LIMIT 1