来自最近10个数据库的最新数据[关闭]

Question

I just wanna show last 10 or 30 depends on list if there is big data, searched over the net but all by correcting I can see only the 1st data not newest one.

$sql = "SELECT id, tag, count FROM url ORDER BY id, tag, count ASC LIMIT 1";

I am testing with two datat on database and want to display last one but all the time it shows the oldest one (first data), I changed ASC and DESC also, both time result is same.

Answer 1

Use this one:

$Query = "SELECT id, tag, count FROM url ORDER BY id DESC LIMIT 10"