Last xx posts, can you correct my code pls.

[Xenon]

nope, that is not possible and will produce an error

[FFMG]

Originally Posted by Xenon

nope, that is not possible and will produce an error

Well, it is working for me http://www.httppoint.com/seo_tool_pr.php

And I have tried with phpMyAdmin and it works as well.

What do you mean by it would cause an error?

FFMG

[Xenon]

hmm, mysql is a bit lazy when handling grouping queries, normaly according to the sql standart that query should produce an errormessage as it's not possible to tell which information of which post should be selected

if it works, then ok, but that can change with new versions of mysql, that's why i wouldn't code it that way.

[PyroNET]

$posts = $db->query_read("SELECT * FROM post INNER JOIN thread USING(threadid) ORDER BY post.dateline DESC LIMIT 3");

while ($posts = $db->fetch_array($posts)) {

echo $posts['title'];

}

Why does this query return one result when there should be many more?